Hi Daniel,
Its working well. Is it possible to the code will affect in specified
range("d5:d36)Regards & Thanks Rajesh Kainikkara On 12/9/10, Daniel <dcolarde...@free.fr> wrote: > Hello, > Here is an example if the setting can be done using row 1 : > > Private Sub Worksheet_Activate() > Dim lastcolumn > lastcolumn = Cells(1, Columns.Count).End(xlToLeft).Offset(, 1).Column > Cells(1, lastcolumn).Select > End Sub > > Regards. > Daniel > > -----Message d'origine----- > De : excel-macros@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_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 <rajeshkainikk...@gmail.com> wrote: >> 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).Select End Sub >> >> Thanks & Regards >> Rajesh Kainikkara >> >> On 12/6/10, Daniel <dcolarde...@free.fr> wrote: >>> 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 open >>> >>> Hi Experts >>> >>> I am using an excel sheet for attendance marking sheet have 31 >>> columns for each day. >>> if i mark the attendance up to 5th , i want to get select the column >>> for 6th day automatically when i open the page.how can write the code >>> 1 a b c d e f >>> 2 1 2 3 4 5 6 >>> 3 x x x x x >>> 4 x x x x x >>> >>> Thanks in advance >>> Ragards >>> >>> Rajesh kainikkara >>> >>> -- >>> --------------------------------------------------------------------- >>> ------- >>> ------ >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>> and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&; >>> ref=ts >>> >>> -- >>> --------------------------------------------------------------------- >>> ------------- Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ >>> http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >>> and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&; >>> ref=ts >>> >> > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and > Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
