| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
e-mail range of cells
Hi Vee,
Instead of strto = Sheets("HPP").Range("F2").Value strsub = Sheets("HPP").Range("A2").Value strbody = Sheets("HPP").Range("J2").Value try something like: strto=sheets("HPP").cells(target.row,target.column-2) strsub=sheets("HPP").cells(target.row,target.colum n-7) strbody=sheets("HPP").cells(taget.row,target.colum n+2) Hope this will help.. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mailing an excel range in the body of an e-mail | Excel Discussion (Misc queries) | |||
| Why do some Excel cells refer to e-mail? | Excel Worksheet Functions | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| Mail a different files to each person in a range | Excel Worksheet Functions | |||
Threaded Mode
