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?


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

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