Validation list from another sheet 1

[lovalles]

i have done this

Public myrange As Range
Private Sub Workbook_Open()
Set myrange = Worksheets("Sheet1&quot.Range("A1:A10&quot

End Sub

i got to sheet2 select the cell
Data>Validation>List
and type
=myrange
but i get the A named Range you specified cannot be found?

how should i do this the right way.
thanks

lovalles

 

[SkipVought]

Hi,

Here's what your code should have stated...

ActiveWorkbook.Names.Add Name:="MyRange", RefersTo:="=Sheet1!" & Range("A1:A10").Address

All you did was set a range object named MyRange. You did not add it to the Names Collection so that it could be used on a worksheet.


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[lovalles]

worked great

thanks SkipVought