Copy Range of cells and paste into email

**Shama** · 01-14-2009, 08:27 PM

Hi:

I have a table in excel that I would like to copy into an email and send to my co-workers on a regular basis.

Somewhere on the net I have find a piece of code (I've omitted a bunch of stuff here):

Please Login or Register  to view this content.

I wanted to know what code to use in the Body so that I can paste range of cells (the table).
Right now I get an "Array lower bound must be zero" error if I just put in the range.

Many thanks,
Shama

**Leith Ross** · 01-15-2009, 12:56 AM

Hello shama,

I wrote this macro a short time ago to do what your asking about. See the example below the code for the calling syntax. Any legal range syntax can be used in the macro.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**Shama** · 01-15-2009, 03:13 PM

Thanks Leith~

I also found this bunch of code on the web (finally) that solved my issue.

Thanks for helping me out~!

Please Login or Register  to view this content.

**vin2122** · 12-17-2012, 04:20 AM

Hi Leith, Shama and everyone.

Would like to ask how Shama activates his codes? Do I need a button (ActiveX Button) and change a Sub line there?

Thanks in advance.

Copy Range of cells and paste into email

LinkBack

Thread Tools

Rate This Thread

Display

Copy Range of cells and paste into email

Re: Copy Range of cells and paste into email

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions