Thread: Hiding columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scottwilsonx[_10_] scottwilsonx[_10_] is offline
external usenet poster
 
Posts: 1
Default Hiding columns

Hi everyone, can anyone help !?

I have a table of information, from A19 to F50 where column has title
and B to F data. The table is linked to other worksheets using th
INDIRECT function and references cell A5 to get the appropriat
sheetname.

What I would like to do is create a VBA macro that will automaticall
hide the rows with no data in either column B or E. is this possible ?


Thanks for any and all help.

Best wishes
Scott

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