Linking to a row or colum, not a cell

[Bryan James]

Does anyone know haw to hyperlink to a row in another sheet so that it will highlight the entire row? And on top of that, is it possible to set it up so that when it takes you to that row, it is in the center of the page?

 

[Brian from Maui]

Bryan,

When you click the Hyperlink icon after saving your workbook, you can specify what worksheet and row and column to link to

 

[Bryan James]

Thanks Brian, but when i do that, it asks for the "cell" reference, and i want it to go to the entire row, not just a cell in that row. Any ideas?

 

[Brian from Maui]

Bryan,

Give a range i.e. A1:D1

 

[Bryan James]

That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business.

 

[Brian from Maui]

On 2002-04-26 09:59, Bryan James wrote:
That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business.

Hot and Sunny

 

[Happy_Dog]

You can just use 10:10 for an entire row.