MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Making the first cell on row the ActiveCell


Posted by Ben on April 18, 2001 12:31 PM

What code do I use to make the ActiveCell become the first cell on the present row?

or:

Is it possible to make a number of macros offset from the same cell. That is Active at the time it is set?
Thanks


Posted by Stephane Parent on April 18, 2001 12:59 PM

This one line code should do the job:

Sub test()
Cells(ActiveCell.Row, 1).Select
End Sub

I hope it helps!

Stephane Parent