Member Avatar for tgifgemini
tgifgemini 12 Junior Poster

Hi,
I need help setting a spreadsheet printing Range because when I print, after printing the area with data, it prints additional blank pages.

So how can I set my print range from "A1" to the last cell that has data?

Example:

xlWksht.PageSetup.PrintArea = xlWksht.Range("A1:???????").Address

Note: in the code above, I do not have idea where the range with data ends.

Thanks.
tgif

  • 1 Contributor
  • 0 Replies
  • 56 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.