Problem to cell value

Hi,
When running macro of attached Excel file, I get error
23g.pngdue to this line
                Worksheets(List1).Cells(RowID2, 9).Value = Mid(Worksheets(List0).Cells(RowID, 9).Value, 1, 350)
Remedy_Incidents_Analysis_-A4-_New.xlsm
LVL 11
HuaMin ChenSystem AnalystAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
It s the = sign at the beginning of the text which is causing the problem. You need to get rid of it at the start. One way is to use a statement like

Worksheets(List1).Cells(RowID2, 9).Value = IIf(Left(Mid(Worksheets(List0).Cells(RowID, 9).Value, 1, 350), 1) = "=", ",", "") & Mid(Worksheets(List0).Cells(RowID, 9).Value, 1, 350)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.