select all cells to be printed on first page [based on

[aLUPIN]

Hello
Searching the net for days now and not coming near any solution...

I want vba code that returns or selects all cells that are within the printable range of page 1 were the print command being.
So based on the margin settings, and the default printer...
!!! [no page breaks are set - no print areas are defined] !!!

In other words the range [on the first page] that is marked by dotted lines
whenever a print preview as made. = gray dotted lines
See here. In this case I would want the Range(A1:AD47) returned

I just have no clue...
Anyone?

Thx for your feedback/efforts
aL

 

[davesexcel]

Are you asking to set the print range from A1 to the last row and last column?

 

[aLUPIN]

Are you asking to set the print range from A1 to the last row and last column?

No,
I want to know what print range is Excel returns when I push on the print button.
Excel visualizes this by a defined area by grey dotted lines (see jpg).
[so excel gets this based on: margin settings, print area settings, page breaks, cell width, row heigth, etc.]