Hello,
The answer to the subject will solve my problem--if I place my cursor in a cell and then start a macro, can I get it to "grab" the row number I'm in for use later in the macro? I've tried a few things with relative references, trying to equate things, and trying to play with the data type, but I can't get it to work.
Thank you!
gle,
Try ActiveCell.Row or Selection.Row
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi tigeravatar,
Thanks for the help. Unfortunately, I can't just use the relative references, because I need the row to transfer over multiple other spreadsheets in the same workbook to perform specific operations there. So (I think) I need a variable that actually defines the row number that would be defined by ActiveCell.Row or Selection.Row. Make sense?
Thanks!
gle,
No, that doesn't really make sense. I was suggesting that you assign a variable to the value of ActiveCell.Row or Selection.Row at the beginning of your macro:
Please Login or Register to view this content.
If for some reason that doesn't work for you, then we're going to need more information.
Sorry, had my mind in a bit of a rut, wasn't thinking about that route to solve the problem. Makes sense! Sorry to bother for such a simple question.
No need to apologize, we've all been there
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks