print data
 

i have linked cells from 1 to 10000 in my worksheet with another worksheet.

the other worksheet comes form transferspreadsheet macro from access and the
data is not always fixed, it depends on the result of the query.

i want to print each time only the cells that actually contain data without
having to set the print area each time.

can i achieve that?