chnage value

[kenpcli]

I need a maco to change the value in column F from 1 to 00.

 

[davesexcel]

You would have to supply additional details, right now all you would have to do is go to the cell that =1 and make it =0

 

[kenpcli]

I have a worksheet that has site code in column "F" and the software brings over 1, I need to change the value of all the cells in column "F" that has a "1" to a "00".

 

[davesexcel]

I believe you would require to set the cell format to text first.

Possibly

Sub Button1_Click()
    Dim LstRw As Long, rNg As Range, c As Range
    
    LstRw = Cells(Rows.Count, "F").End(xlUp).Row
    Set rNg = Range("F1:F" & LstRw)
    
    Application.ScreenUpdating = False
    
    For Each c In rNg.Cells
    
        If c = 1 Then
            c.NumberFormat = "@"
            c = "00"
        End If

    Next c
End Sub

 

[kenpcli]

Thank you, this worked fine.