Reference VBA object within worksheet function "countifs"
Hey guys, so I'm pretty new to VBA and I've been using it at my work a lot lately and I keep having a problem that my code isn't referencing the "=tier" in the countifs. Anyone know how to fix this?
Any help is very much appreciated
Please Login or Register to view this content.
Last edited by pwells; 06-26-2014 at 08:26 AM. Reason: code tags
Tier is a variable but by enclosing it in quotes you are treating it as literal text and the function tries to match the actual word "tier". You need to concatenate the value onto the criteria string:
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
i think you need to put some "" round tier. I'll take a look.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Woah, that worked perfectly! Thank you so much for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks