Cell referencing a span small prob.

[richh]

I was wondering if there was a way for a cell that references a span could spawn at the first cell referenced rather than the last.

example - cell A1 on sheet 1 references cells B1:B52 on sheet 2. When I click on A1, which is hyperlink, it takes me to B52 on sheet 2 rather than B1. Is there a way to make it spawn at B1?

 

[T. Valko]

Thanks both of ya for the help; I'm gonna try to tackle this next Monday as my work day is over. If anything, I'll just have these links go to one cell rather than a range.

Thanks again!!

Let us know how you make out.