deepaksethu
11-22-2006, 10:06 AM
Hi group,
I am new to the world of macros. I would like to know the procedure to clear all existing names defined(bookmarks) in a spreadsheet and assign new bookmarks to the selected row/range of cells against the value/name in the first row of the spreadsheet.
say I have the following as :
Bookmark Name A B C D E F Row 1 1 2 3 4 5 6 Row 2 7 8 9 10 11 12 Row 3 13 14 15 16 17 18 Row 4 19 20 21 22 23 24
Let's assume now that the row 1 with values 1 to 6 has has the bookmark name's A to F . Now I want a procedure to clear those values and set those bookmark values to the highlighted row, say Row 4.
So after the procedure is run, the bookmark will refer to the the cell that has the value 19, B to the cell that has the value 20 and so on.
Thanks
I am new to the world of macros. I would like to know the procedure to clear all existing names defined(bookmarks) in a spreadsheet and assign new bookmarks to the selected row/range of cells against the value/name in the first row of the spreadsheet.
say I have the following as :
Bookmark Name A B C D E F Row 1 1 2 3 4 5 6 Row 2 7 8 9 10 11 12 Row 3 13 14 15 16 17 18 Row 4 19 20 21 22 23 24
Let's assume now that the row 1 with values 1 to 6 has has the bookmark name's A to F . Now I want a procedure to clear those values and set those bookmark values to the highlighted row, say Row 4.
So after the procedure is run, the bookmark will refer to the the cell that has the value 19, B to the cell that has the value 20 and so on.
Thanks