ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Put contents of a range into one variable (https://www.excelbanter.com/excel-programming/378104-put-contents-range-into-one-variable.html)

jille

Put contents of a range into one variable
 
Hi,

I have some data and I want to put it into one variable, if possible. My
intent is to move it into the body of an Outlook message. The data size can
vary from 2 rows x 10 columns to 200 rows. Obviously I would like to avoid
creating a variable for each cell.

Is there a way to do this?

Thanks!

Nigel

Put contents of a range into one variable
 
Named range or an array?

--
Cheers
Nigel



"jille" wrote in message
...
Hi,

I have some data and I want to put it into one variable, if possible. My
intent is to move it into the body of an Outlook message. The data size
can
vary from 2 rows x 10 columns to 200 rows. Obviously I would like to avoid
creating a variable for each cell.

Is there a way to do this?

Thanks!





All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com