VBA code to select particular tab....
Closed
PM
-
Apr 21, 2010 at 09:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 09:59 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 09:59 AM
Related:
- VBA code to select particular tab....
- Vba select case like - Guide
- How to get whatsapp verification code online - Guide
- Samsung keypad reset code - Guide
- Battery reset code - Guide
- Samsung volume increase code - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 21, 2010 at 09:59 AM
Apr 21, 2010 at 09:59 AM
dim dt as string
' if dates/sheet names are like 01, 02 03.. then use "dd" instead of "d"
dt = format(date, "d")
sheets(dt).select
' if dates/sheet names are like 01, 02 03.. then use "dd" instead of "d"
dt = format(date, "d")
sheets(dt).select
