this might help
http://tinyurl.com/2f5ym

--
Don Guillett
SalesAid Software

"Erin" wrote in message
...
I need a piece of VBA code that will select all visible sheets. When I
record a macro, it does it via an array and specifying each sheet name.
But, in my case I don't know how many sheets there are.