What is the code to return the address of the current cell ?
Problem:
I am running through a loop looking for a value so I don't know what row I am on when I hit that value.
When I hit it, I need to know the row number and how to use that number to reference another cell.
Poor code example of what I am after:
rowlocation = get.current.cell.row
activate.cell("A "& rowlocation &" ")
Thanks for any tips....
Sorry if it is a simple question, second day of learning VB for excel...
Bookmarks