Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
I'm sure I have hidden values within a cell. I have this code I used elsewhere in my project, but if I use this one too early as it gives me another problem down the line. How Can I just target Column C and only C? Do I just simply replace "A1" with "C1" and "X" with "C"?
VBA Code:
Sub remove_hidden_Values()
With ActiveSheet
For Each Cell In Range("A1", Range("X" & Rows.Count).End(xlUp))
Cell.Value = Trim(Replace(Cell.Value, Chr(160), Chr(32)))
Next
End With
End Sub