Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Columns Select issue
A simple issue that I'm stuck on -- recording a macro -- select column A followed by doing a replace function. When the macro is ran the entire sheet is selected and any occurrence is changed in all columns. Columns("A:A").Select Selection.Replace What:="N", Replacement:="NOT FOUND"...- BigNorton
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA Replace - Excel 2003
I'm really new to VBA and have a question about Selection.Replace on a cell with numeric values. The quest -- change cells with value '0' to 'UK'. Examples of cell values -- 0; 10; 102; 14, etc. With the following code the each '0' in the value changes to 'UK', so in my examples you get UK...- BigNorton
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
