Rangename problem

[blaksnm]

Hey Guys
Todays second problem:

My filenames is values of (ex) Range("A10") and my macro uses this value to open the file - all is ok

When I insert a new row the filename is now changed to a value of range("A11") but my macro will not read this change automaticly and still look for value in A10

I have tryed to give the cell A10 a name ; "Filename" to with se the influence of the inserted row on the macro result, but the only effect is an error.

Original statement (one of several):
Set wbk1 = Workbooks.Open(Filename:=Range("A10").Value)

Revised statement:
Set wbk1 = Workbooks.Open(Filename:=ActiveWorkbook.Names(Filename").Value)

Where is the road ahead?

 

[jkpieterse]

Set wbk1 = Workbooks.Open(Filename:=ActiveWorkbook.Names("Filename").RefersToRange.Value)

 

[blaksnm]

Thanks, but an error occures:
Run-time error '1004'
"Application-defined or object-definederror

 

[jkpieterse]

Are you sure there actually is a range name called filename?

 

[blaksnm]

Sorry
You are perfectly right about that
I had a dyslectic attack when naming a range in the worksheet.
Error found and corrected - now all is ok
Thanks a lot!

 

[jkpieterse]

Excellent, thanks for letting us know.