Save Active Workbook Range as Lotus Notes Attachment

[bdb1974]

I've got this e-mail program for lotus that saves the active workbook as an attachment. Instead of saving the entire workbook. I'd like to only save
a single sheet with a given range.

Here's an excerpt from the code that works:

Please Login or Register  to view this content.

I'd like to do something like the following:

Please Login or Register  to view this content.

However when I try the augmented code it gives a Run-time error '438':
Object doesn't support this property or method

Any suggestions on this can be done?

Once this is accomplished, I will want to change the Range to a cell reference which will have a Value for the selected range.

Using:

http://www.excelforum.com/excel-prog...input-box.html
Thanks.

the value in the cell to be used will look like: $A$1:$G$30



BDB