rt de Rajesh K R
> Envoyé : mardi 7 décembre 2010 16:18
> À : excel-macros@googlegroups.com
> Objet : Re: $$Excel-Macros$$ Select the next cell when the page open
>
> Hi
> i got a mistake in my code here is the correct one
>
> Private Sub Worksheet_Activate()
> Dim la
acros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajesh K R
Envoyé : mardi 7 décembre 2010 16:18
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Select the next cell when the page open
Hi
i got a mistake in my code here is the correct one
Private Sub Worksheet_Act
Hi
i got a mistake in my code here is the correct one
Private Sub Worksheet_Activate()
Dim lastrow
lastrow = Cells(Rows.Count, 12).End(xlUp).Offset(1, 0).Row
Cells(lastrow, 12).Select
End Sub
Regards
Rajesh kainikkara
On 12/7/10, Rajesh K R wrote:
> HI Daniel
> here is the code what i am using t
HI Daniel
here is the code what i am using the last raw in a work sheet when it activate
i want a code like this instead of row here i want to find the next column.
Private Sub Worksheet_Activate()
Dim lastcolumn
lastcolumn = Cells(Columns.Count, 12).End(xlUp).Offset(1, 0).Row
Cells(lastcolumn, 12
Hello.
Maybe :
Columns(Day(Date)).Select
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Rajesh K R
Envoyé : lundi 6 décembre 2010 17:26
À : excel-macros
Objet : $$Excel-Macros$$ Select the next cell when the page
