Thread: Excel 2000 VBA - Set Print Range in dynamic range
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 Excel 2000 VBA - Set Print Range in dynamic range
Hi
try
ActiveSheet.PageSetup.PrintArea = Range("A1", Cells(rwIndex,
5)).address

--
Regards
Frank Kabel
Frankfurt, Germany


Thanks, Tom, the last one was perfect. Now I need to print that. Have
tried the following:

Range("A1", Cells(rwIndex, 5)).Select
worked great to select teh Range but...

ActiveSheet.PageSetup.PrintArea = Range("A1", Cells(rwIndex, 5))
errors out and

ActiveSheet.PageSetup.PrintArea = RangeSelection doesn't error but
doesn't work either.

Thanks,
Marc


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote