View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wizardmalcolm wizardmalcolm is offline
external usenet poster
 
Posts: 8
Default delete columns if cells have no data

..Hi
I have a worksheet where rows 1 & 2 and columns A & B are fixed headings.
I would like a macro where any columns (C:BH) are deleted if they have no
data.
All of the cells in the range (C3:BH500) have formulas.
I have tried to adapt other similar solutions found here, but to no avail.
Any help would be greatly appreciated.

Malcolm