transferspreadsheet action

[angie]

Θέμα: print data 9/5/2006 6:19 πμ PST

Ανά: angie Σε: microsoft.public.excel.worksheet.functions


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?

 

[Ron2006]

Technically this is an Excel question not an access Question. The fact
that the data came from access is secondary.

If a print range is setup in excel that is what it will print.

If there is no print range then excel will typically print anything
that has data in it.

Take the print range out, and try it.

Check with an Excel Usenet group for more clarification.