VBA code to select particular tab....
Closed
PM
-
21 Apr 2010 à 09:45
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 21 Apr 2010 à 09:59
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 21 Apr 2010 à 09:59
Related:
- VBA code to select particular tab....
- Vba select case like - Guide
- Vba find - Guide
- Cs 1.6 code - Guide
- Ninja up code ✓ - Android Forum
- Unlock code - Phones, PDA & GPS Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
21 Apr 2010 à 09:59
21 Apr 2010 à 09:59
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
