Thread: activesheet.name ending in "-" &Style1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wally Wally is offline
external usenet poster
  
Posts: 9
Default activesheet.name ending in "-" &Style1
I'm trying to find all sheets that end in "-" & Style1

If ActiveSheet.Name Like "??-" & Style1 Then
If ActiveSheet.Name Like "???-" & Style1 Then
If ActiveSheet.Name Like "????-" & Style1 Then

The sheetname could begin with 2 to 4 letters and always ends in - and
Style1 (another series of characters)
Style1 is 1-3 characters long.

TIA
Gerry

Reply With QuoteReply With Quote