Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to clear range contents when cell contents are changed by us Steve E Excel Programming 12 February 22nd 07 09:09 PM
compare the contents of one range of cells with the contents of a. Dozy123 Excel Discussion (Misc queries) 1 January 24th 07 10:14 AM
Bold contents of a variable mikeburg[_79_] Excel Programming 8 February 20th 06 02:26 AM
Set variable to clipboard contents? Fred Smith Excel Programming 2 September 5th 04 08:23 PM
setting a range variable equal to the value of a string variable Pilgrim Excel Programming 2 July 1st 04 11:32 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"