Hello,
I wonder if anyone can help.
I need to goto column A on the same line that I am on no matter how many colums I am to the right, I thought it would be something like range([a,*])
Any ideas
thanks
Gazzer
Hello,
I wonder if anyone can help.
I need to goto column A on the same line that I am on no matter how many colums I am to the right, I thought it would be something like range([a,*])
Any ideas
thanks
Gazzer
Hello Gazzer,
The code below with set the active cell to Column "A" in the same Row.
R = ActiveCell.Row
ActiveSheet.Cells(R, 1).Select
To use the code with a given Range...
With Range("$D$10")
R = .Row
.Cells(R, 1).Select
End With
Hope this helps,
Leith Ross
Last edited by Leith Ross; 03-15-2005 at 05:02 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks