View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PO PO is offline
external usenet poster
 
Posts: 66
Default Cell ID property

Excel 2003, sp2


Hi,

I'm using an add-in to retrieve data from a webservice. The data is "looped"
into a table in a worksheet. Typicaly the webservice returns 200 records.
I would like to store each records ROWSTAMP in column A so that the add-in
can retrieve additional information about that record if the user needs it
(and display the additional information in a msgbox). I do not however want
the rowstamp id to be displayed to the user.

Since the workbook already heavyly relies on ranged names I do not want to
use 200 additional range names to store this type of information. I'd also
rather not use a hiden column or cell comment, the cell.id property seems
like a much "cleaner" way to store this information as it is invisible to
the user.

The workbook will never be saved as a webpage. Are there any drawbacks using
the ID property in this way?

Regards
Pete