This is probably a quick one.....I'm trying to enter a COUNTIF formula into a cell based on a range that is selected by the user. When I try a formula that takes only one parameter the macro works, but when I try it with my COUNTIF formula the macro does nothing.
Please Login or Register to view this content.
Last edited by XL2008; 09-11-2010 at 10:41 AM.
Hello XL2008,
If you want a single formula to return the count of the occurances of A3 then you need to use the Range's Address and not the Range Object.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hey Leith,
It works perfect based on what I gave you.
I forgot about one issue though when I was testing this before. When I select my range from another worksheet it doesn't pass the worksheet name into the formula so if for example I'm in Sheet1 and choose data for the range from Sheet2 A:A, my formula only gets the info A:A and doesn't refer to the sheet I chose the data from.
Hello xl2008,
This version includes the sheet name in the formula.
Please Login or Register to view this content.
Or
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Works perfect, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks