Visual Basic, getting a Run-time error '13': Type Mismatch

I know nothing about visual basic and I'm using an excel spreadsheet that someone created.  All of a sudden I'm getting a Run-time error '13': Type Mismatch. When I go to debug it shows this highlighted:

 

Sheets("FreightTracker").Rows(Rng.Worksheet.Cells(1).Value).Cells(1).Resize(1, Rng.Cells.Count).Value = Application.WorksheetFunction.Transpose(Rng.Value)

 

What do I need to do to get this working again?

 

Question Info


Last updated November 8, 2019 Views 4,096 Applies to:
Answer
Answer
This is not a problem of the code, it's a problem in your sheet, e.g. "Rng.Worksheet.Cells(1).Value" is not a number.

However, a good macro should capture such errors.

Correct your sheet or contact the author to discuss the problem.

Andreas.

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.