View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kanuvas[_2_] kanuvas[_2_] is offline
external usenet poster
 
Posts: 1
Default Doing a macro in every worksheet except 2


Hi all,

I have potentailly unlimited worksheets to my database which can be
added at will, but all have a column which is identical except 2.

I need some code that will look at all worksheets except those two and
carry out my macro.

I thought: For Each Sheet In ActiveWorkbook.Sheets would work but i
cant seem to use it for this.

Any help would be appreciated.


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=477084