For Each Worksheet containing 'XXX'

[RichTea88]

Good Afternoon Folks.

I was wondering how I could write a line that will loop through my worksheets containing 'XXX' in their name.

Currently I have this line

Please Login or Register  to view this content.

Which doesn't work. The rest of the code works fine, it just runs it on every sheet including the ones that dont include 'XXX' in their name.

any ideas how to solve this?

Many Thanks,

R

[Solus Rankin]

try

Please Login or Register  to view this content.

e/ = 0 would imply that instr returned nothing

[ragulduy]

I think you want:

Please Login or Register  to view this content.

For what it's worth:
InStr Function


Returns a Variant (Long) specifying the position of the first occurrence of one string within another.

Syntax

InStr([start, ]string1, string2[, compare])

The InStr function syntax has these arguments:

Part Description
start Optional. Numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified.
string1 Required. String expression being searched.
string2 Required. String expression sought.
compare Optional. Specifies the type of string comparison. If compare is Null, an error occurs. If compare is omitted, the Option Compare setting determines the type of comparison. Specify a valid LCID (LocaleID) to use locale-specific rules in the comparison.

[RichTea88]

You Guys...I Love You Guys.

http://www.youtube.com/watch?v=IjY8_z3QoSQ

Reap Your Reward