Re: Hyperlinks - Named Range to appear at top of worksheet

If the defined range is "MyRng" and it is in row
70, I want row 70 to be
the first visible row of the worksheet.

Marc

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
On Behalf Of Don Guillett
Sent: 23 April 2007 03:29 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Hyperlinks - Named Range to appear at top of
worksheet

>How do I make it so that the
>defined name appears at the top of the worksheet?
I don't understand what you want???? As Bill clinton said,
"it depends
on 
what your definition of "appears" is.

Don Guillett
SalesAid Software
dguillett1austin.rr.com
----- Original Message ----- 
From: "Kantor Marc" <marcSENIORSFINANCE.CO.ZA>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Monday, April 23, 2007 8:01 AM
Subject: Re: Hyperlinks - Named Range to appear at top of
worksheet


Thanks Don. I'm not sure the purpose of the last line of
code ... "
ActiveSheet.Range("a1").Value = Wantedrng".
It is placing the names
range in the cell, but it does not bring the actual named
range to the
top of the sheet.

Marc

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G