The closest thing to a bookmark in Excel is a range name. To
create a name with code, use something like the following:

ActiveWorkbook.Names.Add Name:="TheName", RefersTo:=Range("A1")

To use the name, use code like

Range("TheName").Value = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Bala" wrote in message
...
Hi

We are creating bookmarks on word document and we fill the
values from xml
file to word document using vb6. same like we need to do on
excel file. i
dont know the whats the equalient bookmark concept in excel.
can any one give
me idea?

thanks
bala