Thread: named cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_132_] John[_132_] is offline
external usenet poster
 
Posts: 30
Default 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