Run time error 13 type mismatch

**potga** · 06-23-2014, 10:35 PM

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** · 06-23-2014, 10:40 PM

Hi Potga,

try this

Formula:

Please Login or Register  to view this content.

try it again

Cheers
Lex

**potga** · 06-23-2014, 10:57 PM

lexusap
still get the same error.

**MarvinP** · 06-23-2014, 10:59 PM

How about trying

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

**lexusap** · 06-23-2014, 11:26 PM

Hi,

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

Cheers
Lex!

**potga** · 06-23-2014, 11:33 PM

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

Run time error 13 type mismatch

LinkBack

Thread Tools

Rate This Thread

Display

Run time error 13 type mismatch

Re: Run time error 13 type mismatch

Re: Run time error 13 type mismatch

Re: Run time error 13 type mismatch

Re: Run time error 13 type mismatch

Re: Run time error 13 type mismatch

Thread Information

Users Browsing this Thread

Similar Threads

Run Time error 13 : Type Mismatch

Run-time error 13 - Type Mismatch

Run Time Error '13'. Type Mismatch

run-time error 13 type mismatch

Run-time error '13':Type mismatch

Bookmarks

Bookmarks

Posting Permissions