Error 91 - Object Variable Not Set error with Global Variable

[JungleJme]

Hi,

Not a VBA developer but I am writing private sub within a module that uses two workbook variables which are declared globally. The two variables are MyWbk and TempWbk - both are set in other subs...

Please Login or Register  to view this content.

It is this final line that brings up the 91 "Object Variable not set" error - but the object is Set in an earlier sub...

if i change the Frsthdrtxt in the Find statement to "*" - the statement executes....if i change it to a hard coded text string such as "MYTEXT" - i get the 91 error again....

The purpose of the above statement is to grab the header from A1 in the Temp workbook, assign it to the variable Frsthdrtxt and find that in My Workbook, i thought it would be simple, but i'm getting stuck...

I've tried setting MyWbk and TempWbk to Nothing in the Sub and then putting in the Set statements within the Private Sub in which this line is executing, but that hasn't worked....any help is greatly appreciated!

[Norie]

Sounds like the Find hasn't found anything.

[Izandol]

The error means that your search text is not found. Many reasons why that may be so - perhaps the code is searching formulas rather than values or vv. Better to provide all options for the Find method and then verify that the search data is correct, and the search location as well.

[JungleJme]

Wood for the trees!

I'm a VBA novice really - so immediately assumed that my syntax or declarations were some how wrong.

But you are right! its actually the source data - there was a difference between the header values where i assumed they were the seem - so the find didn't work....!

Thanks so much....feeling a bit stupid but at least it is fixed!