I've been stuck on this for a while now, I hope someone can help. I have the following line in VBA which works.
I need to replace the range $V:$V because it changes depending on which worksheet is active. I have a variable that will change depending on the sheet. How can I work it into the formula using the correct syntax.Please Login or Register to view this content.
Can anyone help please?
Thanks!
Maria
Bookmarks