Hi all,

I have a small problem

I want to drag this hyperlink:

=HYPERLINK("G:\2010-2011\Time Table 2010 - 2011.xlsx - 'Lecture Hours'!B7", "6")

Horizontally with B7 changing to B8, B9, B10 etc...

and "6" to change to "7", "8", "9" etc...

is it possible?