MrExcel Publishing
Your One Stop for Excel Tips & Solutions

From ActiveCell (Row-1 and Column = A)

Posted by Bob on October 24, 2001 9:26 AM

I can offset the Row to be -1 to move it up one row but I cant get the Column to = A

I am using ActiveCell.Offset(rowoffset:=-1, columnOffset:=1).Address
I dont want to Offset the Column because the # over to "A" will change.

Is there an easy answer?

Posted by mseyf on October 24, 2001 10:28 AM

you could try:

Range("a" & ActiveCell.Row - 1).Select

but it will error out it the active cell is already in row 1