Turn on your macro recorder and walk through it once. Start from there and
build your routine. Check back if you have difficulties.

"Anupam" wrote in message
...
in sheet1 I want to add hyperlinks giving reference to other sheets using
Worksheet(index), what will be the VBA code