Search results

Where is your check for square root symbol ?

Hi bosco_yip, Can you change "=SUMPRODUCT((Sheet1!$A$1:$A$50=B$5)*(Sheet1!$B$1:$B$50=$M$3)*(GET.CELL(63,IF(1,+OFFSET(Sheet1!$B$1:$B$50,ROW(Sheet1!$B$1:$B$50)-MIN(ROW(Sheet1!$B$1:$B$50)),)))=GET.CELL(63,$M$3)))" to Row B3-S3 for me ?

Have you searched the Chandoo site for any of the things you want to do ??? Maybe "Remove dashes (-) in columns N,O,P if found any" is some thing you could learn to do with basic excel routines ?

What did you try and what is problem with row 3 ?

Would some thing simple like inserting a new col after col B work ?

Hui has just given you the solution.

Have a look at this site :- https://analysistabs.com/excel-vba/copy-data-from-one-worksheet-to-another/

You have cross posted here -: http://www.vbforums.com/showthread.php?854485-VBA-for-open-multiple-webpage-in-new-tab-(IE)

Try this cleaned up code Sub FMLdailyREPORT() Dim sht As Worksheet Dim LastRow As Long Set sht = ActiveSheet Dim lngLastColumn As Long 'Define variables Sheets("Input").Select 'Go to correct sheet Range("D2").Select ActiveCell.FormulaR1C1 = "$"...

What are you trying to do ?

Why vba and not a formula ?

What quantity is "X" or how is it worked out ?

How about this ?

I have not looked at file and macro, But how can a macro to tell you to enable macros run ???

Thank you for a good explanation.

Hi all. When I try to AutoFill Range("P2").Formula = "=SUMPRODUCT((O1:O111 <> "")/COUNTIF(O1:O111,O1:O111 & ""))" It removes 2 of the "'s Ie:- =SUMPRODUCT((O1:O111 <> ")/COUNTIF(O1:O111,O1:O111 & ")) Any help on how to fix this ?

Can you talk me through "If half Mod 2 = 1"

Thanks Alan This works for an Even number of players, This slight change works for an Odd number of players, Range("A1:F" & half - 1).Copy Range("H1") Range("A" & half & ":F" & lr).Copy Range("O1") Any way to combine both ??

What do you think the difference between clicking on A1 and pressing a "Home" button would be ?

What do you mean "But I would have to go through each WS individually." ??

I have a list of names and other data and i would like to divide into two :- Put in a simple form, 1 1 - 4 2 2 - 5 3 3 - 6 4 7 5 6 7

Try :- activeworkbook.saved = true To force the workbook think of it as saved

If it's a test then maybe you should do it your self ?

As a chess player and club organiser for over 30 years this post has also got me stumped.

This might get you started :- If My.Computer.FileSystem.FileExists("c://Check.txt") Then MsgBox("File found.") Else MsgBox("File not found.") End If