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
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