you can just name range to be print in macro like here-

Range("Range1").PrintOut

Range("G3:H15").PrintOut

"Sherees" wrote in message
...
| How to set a button in excel to print a specified area, for eg if i click
on
| a colum (say, A5), i need to print a specified area immediately.. Please
help
| on this topic
| --
| Life isa journey not a destination