Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA: E xcel - Find sheet if exists and activate
thats brill thank you- britur
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA: E xcel - Find sheet if exists and activate
Hi, Trying to create a macro to find a sheet (SheetName - dd/mm/yyyy) closest to todays date. Code below only finds the sheet name within the quotes and not the format date. Sub Test() Dim sh As Worksheet, flg As Boolean Dim i As Integer Dim lookUpSheet As String i = 0 For Each sh In...- britur
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
