View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 234
Default Insert column and hide columns

I need to hide a number of columns in a sheet and have used Columns
("C:C").EntireColumn.Hidden = True. This is fine but I have 15 columns to
hide and having 15 rows of code seems excessive. Is there a way to declare
the columns and thus apply in less rows of code?

Also, have similar issue with inserting where to say I want to insert 3
rows, I have 3 rows of code.

Thanks, Rob