Hi
make this
sub foo()
dim wks as worksheet
for each wks in worksheets
if len(wks.name)<2 then
' do nothing
else
' your code
end if
next
end sub


--
Regards
Frank Kabel
Frankfurt, Germany

Frank Kabel wrote:
Hi
try something like

sub foo()
dim wks as worksheet
for each wks in worksheets
if wks.name<2 then
' do nothing
else
' your code
end if
next
end sub



James wrote:
Hi Guys

Could some one please advise the best way to cycle through
all the sheets in a workbook whose sheet name length is 2.
So any sheet name longer then 2 character should be ignored

XL2002, VBA

Thanks a lot in advance for your help
- James