Filtering tabs.
 

Good day to you all!
Im at the final stage of my report automation, and here's the new tricky part

Here's the setup. I got about thirty tabs, and i need to perform a macro on
only the ones that contains 06-07 in the name of the tab. Is there a way to
tell excel

if tab contain "06-07" then do "marco"

Until there's no more tabs to do?

Thanks Guys!

Batty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

Filtering tabs.
 

Sub testit()
For sh = 1 To Sheets.Count
Sheets(sh).Activate
x = ActiveSheet.Name
If InStr(2, x, "06-07") Then
MsgBox ("Yes")
Else
MsgBox ("No")
End If
Next sh
End Sub
--
Best wishes,

Jim


"Battykoda via OfficeKB.com" wrote:

Good day to you all!
Im at the final stage of my report automation, and here's the new tricky part

Here's the setup. I got about thirty tabs, and i need to perform a macro on
only the ones that contains 06-07 in the name of the tab. Is there a way to
tell excel

if tab contain "06-07" then do "marco"

Until there's no more tabs to do?

Thanks Guys!

Batty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1