Discrepancies between running macro and stepping through the code.

[VBAwful]

Hi guys,

I have just written a code to convert some numbers from text format (They were imported from a PDF) to number format. The code seems to work perfectly when I step through it and watch what it is doing, however when I assign the macro to a button it causes all the converted numbers to go to zero. My code is below.

Many thanks in advance for your help!

Sub Condition2()
For k = 8 To LastRow
Worksheets("Bordx Format").Cells(k, i - 1).Value = CDec(Cells(k, i - 1).Value)
Worksheets("Bordx Format").Cells(k, i - 1).NumberFormat = "0"
Next k
End Sub

 

[Norie]

Which worksheet is Cells meant to refer to here?

CDec(Cells(k, i - 1).Value)

 

[VBAwful]

Which worksheet is Cells meant to refer to here?

CDec(Cells(k, i - 1).Value)

Youl solved my problem. I included the worksheet object reference i.e.

CDec(Worksheets("Bordx Format").Cells(k,i-1).Value)

and it worked.

Great spot and thank you!!