+ Reply to Thread
Results 1 to 1 of 1

Referring to range and store values

  1. #1
    Registered User
    Join Date
    02-16-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    78

    Referring to range and store values

    Hi,

    I have a worksheet and I have named some ranges for some cells in the in, worksheet. (I did it by right click on the cell and choose Name a Range.... and gave a name for the cell.)

    Now i have a xml which contains nodes with the same name as the name of the range. Now I want to populate values in the sheets cell from the xml for each range that is named sheet .

    For eg:

    Please Login or Register  to view this content.
    Cells in the worksheet have a namerange as bookid and bookname.
    Now for those cells i want to store 100, abcd respectively.

    I can for loop each node in the xml , but i dont want to hardcode bookid, bookname in the for each loop for the node name and also range name, eg

    Please Login or Register  to view this content.

    How can i achieve this??
    Last edited by Ranjani; 03-05-2009 at 11:56 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1