View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
Posts: 238
Default hiding then printing a row

It depends what exactly you are trying to do. One option is to replicate all
your data further down the sheet and set this as the print area.

Another option is to use VBA to unhide the row before printing and use a
timer to hide it again. This method is more complicated and assumes it is
always the same row(s) you have hidden.

--
Ian
--
"S S" wrote in message
k...
If I hide a single row when viewing, is there an easy way to have this
row included when printing without having to go back to `unhide row`

thanks