Print - Macro help!!

B..

New Member
Joined
Apr 14, 2009
Messages
5
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? :biggrin:

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

Muchly appreciated!
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Hello and welcome to MrExcel.

Try

Code:
Sub Prt()
ActiveSheet.PrintOut
End Sub
 

B..

New Member
Joined
Apr 14, 2009
Messages
5
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! :confused:

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

Cheers!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,721
Messages
5,597,758
Members
414,171
Latest member
12Rev79

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top