Re: $$Excel-Macros$$ Re: Tab name changes, macro references old name

2010-12-14 Thread prabhakar thakur
Dear All Group Member, Kind Attn- Mr. Ayush Jain, I need a excel macro book for start to bottom level creating macro, preparing interview skill & help VB also. Please suggest. Thanks, Prabhakar Thakur New Delhi +919953736776 On Sat, Dec 11, 2010 at 1:39 PM, Ayush wrote: > Hi Pete, > > No Qu

$$Excel-Macros$$ Re: Tab name changes, macro references old name

2010-12-13 Thread Pete
Thank you! Pete On Dec 11, 2:09 am, Ayush wrote: > Hi Pete, > > No Question is silly question... :) > > In case the sheet name changes, you can give reference of sheet index. > Here is example: > > USE --> Sheets(3).Select > The digit 3 is the 3rd sheet of the workbook. > > I hope it helps. P

$$Excel-Macros$$ Re: Tab name changes, macro references old name

2010-12-11 Thread Ayush
Hi Pete, No Question is silly question... :) In case the sheet name changes, you can give reference of sheet index. Here is example: USE --> Sheets(3).Select The digit 3 is the 3rd sheet of the workbook. I hope it helps. Please let us know if you have any further questions. Keep Posting !