Access Excel Cell by Name

[johnoc]

Has anybody accessed Excel cells by name rather than cell numbers? Similar to bookmarks in word.

I ahave created a data sheet template in excel. I fill in this template from xml data generated during a test run. I would like to use names as it can be more descriptive than cell numbers. 

[HectorBeristain]

I think you may be looking for Range("C2")

As to formatting information, this is available through various properties of the Excel object model.

See http://msdn.microsoft.com/en-us/library/ff197454.aspx for more information.

The Range type (as opposed to the Range indexed property referenced above) also exposes a Name property, which you can set in code:

worksheet.get_Range("C2").Name = "fdafdfs"
worksheet.get_Range("fdafdfs").Select();

[johnoc]

Thank you Hector!