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
