How can I get current position of cell ?
Posted by P. P. Ervo on September 28, 2001 3:01 AM
Jep, I posted a question few weeks ago, but I wasn't sharp enough, so I didn't asked right question.. sorry.
So, I need to know in which cell I am in that current situation. Okay, somebody answered to me last time and it worked that way. But output wasn't in correct format. It was something like this: $A$1. I need it in format A and 1. And I dont have any idea how can I divide that output to two separate outputs. Example. If output is A1, I need two separate outputs that are, in this case, A and 1.
Posted by Ian on September 28, 2001 3:21 AM
Re-post your original question and the reply, or post the link to your original question.
Posted by P. P. Ervo on September 28, 2001 4:23 AM
Posted by P. P. Ervo on September 28, 2001 4:25 AM
Posted by Mark O'Brien on September 28, 2001 4:52 AM
curloc = ActiveCell.Address(RowAbsolute:=False, ColumnAbsolute:=False)
Posted by Juan Pablo on September 28, 2001 5:32 AM
If you need to know which row and column in two different variables use:
actrow = ActiveCell.Row
actcol = ActiveCell.Column
Juan Pablo
-------------- curloc = ActiveCell.Address(RowAbsolute:=False, ColumnAbsolute:=False)
