Getting an error message and can't figure out why

I have a macro to create a directory and save the current workbook into it. It then opens up a second workbook, and I get a "Type Mismatch" error, and I don't know why.

Please Login or Register  to view this content.

I'm not 100% sure how to transfer data between workbooks.

Thanks!

This one
Workbooks(TrackingSht).Sheets("Meter Closure Lookup").Range("C3") = Workbooks(ClosureSht).Sheets("FORM").Range("H26")

And probably the two after it.
Thanks!

Once you open the workbook "TrackingSht", try activating the required sheet and then doing simple range statements - sometimes Excel can be funny about long references to cells.

Interesting,
I gave it a try by doing this:

Please Login or Register  to view this content.

and now I get a "subscript out of range" error.
Thanks!

Please Login or Register  to view this content.

? Try that