| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign multiple cell's values to a variable
Need exact VBA code syntax to assign a workbook (to be closed) sheet's cells J4 to J72 values to a variable called "ColJValues" to be assigned to another sheet (to be opened later in the macro). The values are all dates. Once the other workbook is opened later in the macro, need the exact syntax to assign the value in the above variable, "ColJValues", to it's cells J4 to J72. This would greatly help a learner. Thanks, mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=564020 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieving multiple corresponding values with variable rows/column | Excel Worksheet Functions | |||
| how to sum all values of a variable that's repeated multiple times | Excel Worksheet Functions | |||
| Lookup Multiple Values from a variable table size | Excel Worksheet Functions | |||
| Assign value to a variable name | Excel Discussion (Misc queries) | |||
| Assign value to variable | Excel Discussion (Misc queries) | |||
![mikeburg[_95_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
