View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 414
Default printing selected sheets

I have been fiddling around for a while now trying to get my workbook to only
print worksheets that have data on them. Im quite new to visual basic and not
that great at it.

Is it possible to run a macro that can look to see if certain cells are
empty in a worksheet, and if so, not print that worksheet and go onto the
next one? So that it only prints worksheets that have had data entered onto
them.

If so, could you give me ideas on how to do it?