View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave B[_9_] Dave B[_9_] is offline
external usenet poster
 
Posts: 22
Default Print only columns (or ranges) that have at least one currency val

Maybe something like.....

Sub PrintCurrencyColumns()
For j = 7 to 18
bHide = True
For i = 1 to 2 '(or 1 to
Cells.SpecialCells(xlCellTypeLastCell).Row)
If IsNumeric(Cells(i,j).Text) = False Then bHide = False
Next i
If bHide = True Then Columns(j).Hidden = True
Next j
'code for printing here, don't remember offhand, but the
'macro recorder might help, maybe ActiveSheet.Print?
Columns.Hidden = False
End Sub