Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" with ce
Greetings,
Am currently seeking a way to store date,row,col info WITH each cell. Q. Do cells have a user-defined (string) property? This question grows out of a need to simplify associating a cell with some other detail. For more detail, please see my previous post! Thanks/Cheers! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" with ce
Hi tbd
As for row and column you can use the Activecell.Address member (which returns a string). By date do you mean the date in the cell or the date which the cell was modified? If this helps please click "Yes" <<<<<<<<<< "tbd" wrote: Greetings, Am currently seeking a way to store date,row,col info WITH each cell. Q. Do cells have a user-defined (string) property? This question grows out of a need to simplify associating a cell with some other detail. For more detail, please see my previous post! Thanks/Cheers! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" wit
Hi Engineer Rick,
Thank you for your reply! I'll look into using "Activecell.Address" for generic string storage - actually I only need to store/read-back about 16 bytes. My reference to "previous-post" was misleading because I managed to post twice. To see the relevant thread, look for "Does VBA support flattening" a few posts back, or use the search option with same phrase. I really hope there's 16bytes of space I can use with each cell - it will save me from having to add yet another sheet to the project! Luck/Cheers! "BSc Chem Eng Rick" wrote: Hi tbd As for row and column you can use the Activecell.Address member (which returns a string). By date do you mean the date in the cell or the date which the cell was modified? If this helps please click "Yes" <<<<<<<<<< "tbd" wrote: Greetings, Am currently seeking a way to store date,row,col info WITH each cell. Q. Do cells have a user-defined (string) property? This question grows out of a need to simplify associating a cell with some other detail. For more detail, please see my previous post! Thanks/Cheers! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" wit
Hi tbd,
The whole point of '.Address' is that you don't need to store the cell's address - Excel can tell you what it is at any time. Storing the address becomes problematic if any cells are inserted/deleted above or to the left of a cell for which the address has been stored. -- Cheers macropod [Microsoft MVP - Word] "tbd" wrote in message ... Hi Engineer Rick, Thank you for your reply! I'll look into using "Activecell.Address" for generic string storage - actually I only need to store/read-back about 16 bytes. My reference to "previous-post" was misleading because I managed to post twice. To see the relevant thread, look for "Does VBA support flattening" a few posts back, or use the search option with same phrase. I really hope there's 16bytes of space I can use with each cell - it will save me from having to add yet another sheet to the project! Luck/Cheers! "BSc Chem Eng Rick" wrote: Hi tbd As for row and column you can use the Activecell.Address member (which returns a string). By date do you mean the date in the cell or the date which the cell was modified? If this helps please click "Yes" <<<<<<<<<< "tbd" wrote: Greetings, Am currently seeking a way to store date,row,col info WITH each cell. Q. Do cells have a user-defined (string) property? This question grows out of a need to simplify associating a cell with some other detail. For more detail, please see my previous post! Thanks/Cheers! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" wit
Hi Rick,
There's been a misunderstanding! There's a large amount of "context" you will find if you look at the recent post "Does VBA support flattening". The second paragraph describes why I need to store a date/row/col with each cell. The row/col I need to store are not the absolute row/col of the cell (but it's VERY interesting to know that info's there - for future options.) Cheers! "macropod" wrote: Hi tbd, The whole point of '.Address' is that you don't need to store the cell's address - Excel can tell you what it is at any time. Storing the address becomes problematic if any cells are inserted/deleted above or to the left of a cell for which the address has been stored. -- Cheers macropod [Microsoft MVP - Word] "tbd" wrote in message ... Hi Engineer Rick, Thank you for your reply! I'll look into using "Activecell.Address" for generic string storage - actually I only need to store/read-back about 16 bytes. My reference to "previous-post" was misleading because I managed to post twice. To see the relevant thread, look for "Does VBA support flattening" a few posts back, or use the search option with same phrase. I really hope there's 16bytes of space I can use with each cell - it will save me from having to add yet another sheet to the project! Luck/Cheers! "BSc Chem Eng Rick" wrote: Hi tbd As for row and column you can use the Activecell.Address member (which returns a string). By date do you mean the date in the cell or the date which the cell was modified? If this helps please click "Yes" <<<<<<<<<< "tbd" wrote: Greetings, Am currently seeking a way to store date,row,col info WITH each cell. Q. Do cells have a user-defined (string) property? This question grows out of a need to simplify associating a cell with some other detail. For more detail, please see my previous post! Thanks/Cheers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do cells have a string-property I can use to store "stuff" with ce | Excel Programming | |||
VBA code store address with areas separated with "," and I need it sometimes with ";" instead | Excel Programming | |||
Multiple "Range" with "Cells" property? | Excel Programming | |||
Multiple "Range" with "Cells" property? | Excel Programming |