| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning values from a selected range to individual variables
A user selects a range (eg: Range("A1:C1")) and runs a macro. The macro should then assign the value from each cell to its own variable. So cell A1 = 2, B1 = 4 and C1 = 6 and the variables should end up with NumA = 2, NumB = 4 and NumC = 6.
The problem is that I want to be able to handle any size of selected range the user would make and then assign the given number of values to an individual variabel. Can anybody help out? Thank you Schwartz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning cell values to variables | Excel Discussion (Misc queries) | |||
| Convert Data Range in to individual values | Excel Discussion (Misc queries) | |||
| Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K | Excel Worksheet Functions | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| Assigning Selected Cells to Code | Excel Programming | |||
![Dr. Schwartz[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
