VBA Variant Arrays help.

[ash.mak]

Hi All,

I have following returning Run-time Error type 13. Type mismatch. I don't understand why?

dim WFMBlock1 as string
dim WFMDR1 as variant
dim Block1S , Block1E as long

Block1S=2
Block1E=19

WFMBlock1 = ActiveWorkbook.ActiveSheet.Range(Cells(5, Block1S), Cells(36, Block1E)).Address
WFMDR1 = ActiveWorkbook.ActiveSheet.Range(WFMBlock1)

 

[mjbeam]

Your code works for me.

 

[Andrew Poulsom]

Try:

WFMDR1 = ActiveWorkbook.ActiveSheet.Range(WFMBlock1).Value

 

[ash.mak]

Thanks Guys,

I is not working yet. I have declared those variables in the module and not the procedure. But I am using them in a procedure. Could this be the problem? If so, I do not know how to correct that. I need to keep those variables in Module because I am using them in 5 different procedures. Can you help?

 

[ash.mak]

Thanks a million Andrew. You're extremely valuable person I would say.

I saved the sheet and restarted excel and added .value to the range and PRESTO!! it is working. I only need figure out who is more exhausted today, me or the PC.