Print current screen button - Excel

[slipd]

Hey guys,

I need to make a button/macro that will allow me to print what's currently in view in excel...

Any thoughts? I tried Googling a few things but none of them have worked out

Cheers!

 

[slipd]

Thanks guys! It's for printing out page 1 only, the worksheet in view...

The spreadsheet fits on screen but prints out on about 6 side of a4 with bits and pieces all over the place! Macro it is then

Presumably when I do it will just look for the default printer? I ask because I may eventually pass this file on to colleagues and I don't want their file looking for my printer, if that makes sense

Cheers!