feel better now?

Sub setprintarea()
ActiveSheet.PageSetup.PrintArea = _
Range(Cells(4, 4), Cells(12, 8)).Address
End Sub

--
Don Guillett
SalesAid Software

"Patch61" wrote in message
...
Once again I am frustrated by the almost useless Excel VBA programming
help.
Why does such a large commercial program have such crappy help? I had
better
programming help back in the days of programming on the Atari ST!

I need a way to set the print area where I know the starting and ending
columns and rows. The only example the help gives is for the
'CurrentRegion.'
There is no current region set, nor do I want to force the user to make
one.

I would prefer being able to use column and row numbers as opposed to the
A1:G20 method. One would think this would be a simple thing, but here I
am.

Any help will be appreciated.

-Steve