| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I select a cell based on the Column name
I want to search my spreadsheet for specific values and replace them. As my
sheet is huge I want to start my search in row 1 of a specific column. The problem is I may add columns in front of the one I am currently using to start my search and replace. I want to be able to find the column heading titled "New Deals" and then go to the cell directly below it and begin my search and replace macro. If the column heading "New Deals" moves from the 5th to the 6th column I still want to be able to use the same macro without having to go in and change it everytime. HELP! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Range based on column name and not A1 notations | Excel Discussion (Misc queries) | |||
| Help tonight?!! select rows based on cell value in a column | Excel Worksheet Functions | |||
| Select a column based on a index | Excel Programming | |||
| Select a column based on a cell entry | Excel Programming | |||
| Macro to select rows based on a value in a column | Excel Programming | |||
Threaded Mode
