Thread: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
  
Posts: 172
Default Sending ONLY Range or Page x, BUT not entire Activesheet, How ?
I want to adapt this:
.HTMLBody = SheetToHTML(ActiveSheet)

How can i only have a selected range of cells, or a selected page sent in the body of an email instaed of the entire sheet as it currently does?
Any idea's ??

I want to send a range of ("A45:I107") or
Page 1


Corey....
Reply With QuoteReply With Quote