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
