Select first cell in active row?
in [Programming]
|
From: Wes_A on 6 May 2010 23:20 Good day all. Excel 2007 Can anyone assist with code to select the first cell in whichever row the currently active cell is to be found? If I record "Home" the macro given refers only to that specific cell, I need a dynamic result dependent an currently active row in the sheet. Thanks in advance for your always valued contributions. Wes
From: Rick Rothstein on 6 May 2010 23:22 Try this line of code... Cells(ActiveCell.Row, 1).Select -- Rick (MVP - Excel) "Wes_A" <WesA(a)discussions.microsoft.com> wrote in message news:F51A2180-AA8C-4D12-A8BC-8672F2988269(a)microsoft.com... > Good day all. Excel 2007 > Can anyone assist with code to select the first cell in whichever row the > currently active cell is to be found? > If I record "Home" the macro given refers only to that specific cell, I > need > a dynamic result dependent an currently active row in the sheet. > Thanks in advance for your always valued contributions. > Wes
|
Pages: 1 Prev: Loop in Excel Next: please help about handling "#NUM!" error ! |