How to store additional attributes for a cell
Hi Thorsten
The only one I can think of is the ID property
Sub test()
Sheets(1).Cells(2, 3).ID = "Harald's cell"
MsgBox Sheets(1).Cells(2, 3).ID
End Sub
But it doesn't save between sessions, so it's useless for storage. Id'
rather write to corresponding cells in a hidden sheet, given that "should
not be displayed" means only that and not that the information is top
secret.
HTH. Best wishes Harald
"Thorsten Walenzyk" skrev i melding
...
Hi all,
I'm looking for a possibility to store some additional attributes for the
cells in my sheet.
My VBA script needs some data for later decission making.
The additional data should not be displayed for to the user.
Does a Cell object has a property which I can use for that purpose?
Thanks a lot, Thorsten
|