MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)