View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
June June is offline
external usenet poster
 
Posts: 5
Default Set Print Area with a macro

I am automating Excel thru Access. I have am exporting a
query to Excel and then formating it to print. Sometimes
I may have 200 records and sometimes I may have 50. I
want to set the print area in the macro. How do I do
this? Does anyone have any code I could use for a jumping
off place?