I am trying to change the text format from a text cell to a general format cell i currently running a FOR NEXT loop.
this is what i currently have but its not making any changes,
Set objCell = objWksh.Cells(CurrentRow, 16)
With objCell.Select
objCell.Replace.NumberFormat = "General"
objCell.Replace.Value = .Value
End With
any thoughts