Print - Macro help!!

[B..]

Okay im a complete novice to Macros and VB! I did it once at school, that was 5 years ago so as you can imagine my mind is mush as far as Macros go!

What i have is something im creating for work, i should never have started it!

I managed to create my macro for clearing cells after 2 hours searching and chopping and changing but now i give in. Its beat me with a big stick.

So, anyone feel sorry for me and want to give me the code so i can print out the report at the click of a button?

I have my button made and i've tried codes that are useless in all honesty

Muchly appreciated!

 

[VoG]

Hello and welcome to MrExcel.

Try

Sub Prt()
ActiveSheet.PrintOut
End Sub

 

[B..]

Brilliant!!!!!

Thank you so much!!

I can create wonderful things but when it comes to coding it has me stumped, i just dont understand any of it!

I want to do more things like this so ill probably be back more often!

Cheers!!!