| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select columns and replace data
I want to loop through a range of colums and do a replacement like below. Is
there an easy way to do this via a marco? Columns("AQ:AQ").Select Selection.Replace What:="ap$", Replacement:="AQ$", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Columns("AR:AR").Select Selection.Replace What:="ap$", Replacement:="Ar$", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select dynamic data in 2 columns, and repeat macro to next sheet | Excel Discussion (Misc queries) | |||
| How do I replace/select new fields in pivot table using a macro? | Excel Discussion (Misc queries) | |||
| Automatically Accept Replace Values in Text-to-Columns macro | Excel Programming | |||
| Macro won't select columns | Excel Discussion (Misc queries) | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
Linear Mode
