Run-time Error: 1004 Application Defined or Object Defined Error

[FranktheBank]

Hey again,

I'm running this Macro from my main Workbook: "New_Reconciliation." The macros last command has me Active in Workbook "Cadet" (both Workbooks are now open).

The below is supposed to take the value from the Named Range "Last_601" which is located in "New_Reconciliation." and find that value in "Cadet."

I'm getting the error: Run-time Error: 1004 Application Defined or Object Defined Error

When I scroll over the code: MySearch = Range("Last_601").String I get the messages:

MySearch=Empty

Quick Watch gives me MySearch Value <Out of Context> and Range <Expression not Defined in Context>

Please Login or Register  to view this content.

Anyone got any great insights??

PS I declared Dim Last_601 As String above in the coding in case anyone thought I had forgot.

[stnkynts]

.String isn't anything. What are you trying to do with that line? Put the values into an array?

Also you indicate you have multiple open workbooks. You need to declare workbooks and worksheets for your ranges or else you are going to have issues.

[Norie]

There is no String property, you should use Value.

However that might not be the problem, have you checked the named range 'Last_601' is returning a valid reference?

Have you tried adding a worksheet reference for that range?

Please Login or Register  to view this content.

PS No need to declare Last_601 but that shouldn't be a problem, though it might be worth removing the declaration just in case.

PPS Where are you setting ws to refer to the sheet 'Cadet'?