practice.xls
Hello guys,
I have a problem with the macro for sheet1 of the attached spreadsheet. When it performs the COUNTIF() it only returns the value of TRUE instead of the number. The while loops work as wanted but can anyone tell me what is wrong with the equation? I am assuming I am using a reference that isn't allow in this equation.
The values in the worksheet are completely random, they are just there to see if it worked.
Thanks,
You have not attached a macro with your sheet (Not XLSM)
AB33,
Its an excel 2003 file so it does not need to have the .xlsm extension.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Is it the code called proTest?
If it is the problem is because this is a logical expression.
It's testing if "=COUNTIF(Range(""D:D"")," is greater than " & Range(""Selection.Value""))"
Please Login or Register to view this content.
Try this instead.
Please Login or Register to view this content.
Last edited by Norie; 12-06-2012 at 01:29 PM.
If posting code please use code tags, see here.
Thanks a lot thats perfect. As I am new to the visual basic language can you tell me what the & does around the selection.value?? thanks
& is the concatenation operator and is used to join strings.
In this case it's being used to add Selection.Value into the fomula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks