Try:
ActiveSheet.PageSetup.PrintArea = "$A$1:$B$8"
--
Gary''s Student


"Mike" wrote:

Hi
All i want to do is press a form button and print out a cell range, there
are multiple buttons on the spreadsheet each on to print a different range of
cells on same sheet i used this "ActiveSheet.PrintOut.PageSetup.PrintArea =
"A8:B8" to try and doi it changing the print area but it keeps saying there
is an error, any ideas anybody please, or is there another way to do it
--
thanks
Mike