millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
Below is the simple loop I am trying to use. It is just a very small section of the total project but should be plenty to solve the problem.
Set WS2 = Worksheets("Report")
FinalColumn2 = WS2.Cells(3, 230).End(xlToLeft).Column
x = 0
For x = 4 To FinalRow2
If Cells(x, FinalColumn2 + 2).Value = "#N/A" Then Cells(x, FinalColumn2 + 2).Value = "0"
Next x
The variables are all storing correctly I just get a type mismatch error. Not sure what I am doing wrong.
Thanks
Set WS2 = Worksheets("Report")
FinalColumn2 = WS2.Cells(3, 230).End(xlToLeft).Column
x = 0
For x = 4 To FinalRow2
If Cells(x, FinalColumn2 + 2).Value = "#N/A" Then Cells(x, FinalColumn2 + 2).Value = "0"
Next x
The variables are all storing correctly I just get a type mismatch error. Not sure what I am doing wrong.
Thanks