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 different sheets require different columns as a reference. 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.
Any help is greatly appreciated!
Thanks!
Maria
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-11-2014 at 10:53 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-11-2014 at 10:53 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
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
Haripoupuri,
Thank you, this helps, but how would I do this if my variable is just the column number? Do I have to have it in a different form?
Nathansav,
I understand what you did, I guess my question now is the variable is driven by the active sheet so I don't know I would get it to the format you wrote it in.
Are you not still using ActSheet in my way?
Please Login or Register to view this content.
Nathansav,
I tried that but it still doesn't work. My variable is the name of the sheet, which matches the name of the column that needs to be refereneced, how would I write in into the variable like you did MyStr?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks