Thread: Print page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Print page

Hi
try something like
sub foo()
activesheet.printout from:=1, to:=3
end sub

and assign a button to this. You can replace the 'from' and 'to' number
with a variable


--
Regards
Frank Kabel
Frankfurt, Germany

Jez wrote:
I've set my page breaks and want a button to print
ceratin pages. How do I write this in the vba editor?