Print preview range with margins

[~TaC~]

Hi,

When sample workbook is populated there will be date in columns A:G, I want to print a report that doesn't include irrelevant cells so would like to print range A7:G lastrow when the Print Report button is clicked.

Currently I have this code that goes to print preview with the right range selected but when I close preview an error occurs saying that its a formula that starts with =/-

Please Login or Register  to view this content.

Basically looking for code that will print preview A7;G lastrow with narrow margins

When I try recording a macro it comes back with

Please Login or Register  to view this content.

Anyone got any ideas please.

Down the line I would probably change print preview to direct printing if the right settings are default.

Thanks

[Logit]

.

Please Login or Register  to view this content.

[~TaC~]

Thanks, almost right result. this limits column G to row 345 where in OP I said I would like to print A7:G & lastrow (I forgot the &)

[~TaC~]

Thought I fixed it but haven't.

Changed code to:

Please Login or Register  to view this content.

incorporating my original range code, previews the right data but when closing print preview shows following error

Run-time error '1001:

There's a problem with this formula.

Not trying to type a formula?
When the first character is an equal ("=") or minus ("-") sign, Excel
thinks its a formula:
•you type: =1+1. cell shows: 2

[~TaC~]

Think I fixed it with this code

Please Login or Register  to view this content.

Print previews required columns to last row with narrow margins so all nearly good however when I close the print preview box the system goes to 'not responding' for a few seconds and then recovers. Is this normal or error in code?