Problem with DO Wend Loop

Hi Guys, can you tell me why my code is populating the cells (i,18) & Cells(i,20) with "VALUE#"? I enclose my attachment:


ElseIf Cells(i, 6).Value = "ANCOVBONDM" Then
Cells(i, 18).Value = "-832191"
Cells(i, 20).Value = "0.00"
Cells(i, 23).Value = "0.00"
DummyRec9.xlsm
JustincutAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
The columns that are "VALUE#" are S and U which in Cells() is 19 and 21, not 18 and 20, so the code you show doesn't apply (at least not how it is written).
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.