Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
Is there a way to save and refer to a cell with a one name variable?
Instead of range something or cells(1,2) or "A1" can you just call it, like, "ThatCell". Like... ThatCell = Cells(1,2) and then ThatCell means Cell(1,2) not the value that is in cell(1,2). I am doing a trial and error solution and have to save the cells I've tried... not their value. I am hoping to save them in an array. I know I can save them in an array Saved(x,y) with the colum,row coordinates... it's just kind of a pain. I'd like to end up with trial(1) trial(2) etc . thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many named cells | Excel Programming | |||
Excell named cells or labeled cells question | Excel Programming | |||
Excel named cells or labeled cells question | Excel Programming | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Reffering to named cells | Excel Programming |