View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart Steven Stuart Steven is offline
external usenet poster
 
Posts: 3
Default Hide Rows and Columns

Hi,

Is there a way of running a macro (or worksheet function)
that, for every worksheet within a workbook, looks at each
sheet and finds the last column that contains data
and "hides" every column thereafter, and also looks for
the last row that contains data and "hides" every row
thereafter??

Many Thanks,

Stuart.