Run time error 13 type mismatch

[potga]

Hello
There is probably a really simple reason why I get this error but I have wasted ages trying to figure it out.

Have a userform with 2 file pickers to select 2 workbooks which opens the workbooks OK. Now I want to create a variable with the value contained in one of the cells in one of the workbooks.

The last line of code gives the error. Any ideas?

Please Login or Register  to view this content.

[lexusap]

Hi Potga,

try this

Please Login or Register  to view this content.

try it again

Cheers
Lex

[potga]

lexusap
still get the same error.

[MarvinP]

How about trying

var1 = Workbooks(wbOpen1).Worksheets(Sheet1).Range("F9").Text

[lexusap]

Hi,

what is the value of your WbOpen1 ? can you check?

Cheers
Lex!

[potga]

Was a really simple reason. Cell I was trying to get the info from was a merged cell.