| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setup a macro to select a specific column within the same row
How would I setup a macro to select a different cell column within the same
row? I know that I can use the ROW() function to identify the current row. But I'd like to setup a macro that would goto, let's say, column E of the current row. I've tried concatenating, using formaulaes like "EROW()", "E + ROW()", "$E$ROW()" and more but nothing seems to work for me. The idea being that regardless of current cell, I can make select a specific column within the same row for cell data replacement purposes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate cell with specific text and select that column | Excel Discussion (Misc queries) | |||
| Select specific column for auto filter | Excel Worksheet Functions | |||
| How do I select cells within a column that contain a specific word | Excel Worksheet Functions | |||
| select rows to print where there's data in specific column | Excel Discussion (Misc queries) | |||
| How do I pause a macro to select specific cells | Excel Worksheet Functions | |||
Threaded Mode
