Macro - Insert Cells

[ChocksterNo1]

Hi

I have a menu page on a report, in column B from rows B6 to B27, there are hyperlinks to each worksheet in the report.

I need to move the hyperlinked cells 1 or 2 cells to the right dependent on the text in the hyperlink.

I was thinking if I put a hidden table below and did a vlookup, I could move the hypelinked cells would 1 or 2 colums to the right.

e.g.

if text in hyperlink is found in the hidden table, the cells would move 1 cell to the right, if not found then move 2 cells to the right.

Can this be done?

Thanks

Chock