Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preserve a range information
Hi, consider this easy statements: ----- Dim Cell As Range Set Cell = Workbooks("Book1").Sheets(1).Range("A1") ----- As I understand, the variable Cell "points" to Range D7 and when I wan to get some property from the range the Cell ask for it and return it t me. If the workbook is closed the variable "Cell" stops working. Is it possible to *copy* the range to the Cell variable so the variabl continues to live after the workbook is closed? I don't want to make new sheet and copy the range to that, I just want to use the memory. TIA /Nick -- Nick ----------------------------------------------------------------------- Nicke's Profile: http://www.excelforum.com/member.php...nfo&userid=293 View this thread: http://www.excelforum.com/showthread.php?threadid=27109 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print only range that contain information in excel 2007 | Excel Discussion (Misc queries) | |||
Pull information based on a range of numbers | Excel Worksheet Functions | |||
How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
How to preserve cut/copy range on SelectionChange event? | Excel Programming | |||
Passing information from VBA variable to Excel range | Excel Programming |