Thread: Running Macro on every sheet in Workbook !!!
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
  
Posts: 1,080
Default Running Macro on every sheet in Workbook !!!
Try:

wks.Range("A:A,F:F,K:L").EntireColumn.Hidden = True

--

Vasant




"Jako " wrote in message
...
OOoooopps!!

Spoke to soon Tom.

wks.Columns("A:A,F:F,K:L").Hidden = True

comes up with Type mismatch error !!!


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote