Thread: code question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shu of AZ Shu of AZ is offline
external usenet poster
 
Posts: 130
Default code question

In the code below, if I wanted to activate any sheet with a name that
included _U.csv, is there a wildcard I can use?

Windows("Bel080607_u.csv").Activate
Range("A:C,E:E,G:G").Select
Range("G1").Activate
Selection.Delete Shift:=xlToLeft
Columns("A:A").Select
Selection.Cut
Columns("C:C").Select
Selection.Insert Shift:=xlToRight
Range("A2:C350").Select
Selection.Copy
Windows("WiseGuy66.XLT").Activate
Sheets("R1").Select
ActiveWindow.LargeScroll Down:=1
Range("B62").Select
ActiveSheet.Paste
ActiveWindow.ScrollRow = 1
Range("A1").Select
Sheets("DataSorter").Select
Range("A1").Select
End Sub