| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
going 3 columns over in a macro
Hello,
I recorded a macro and have a small detail I need to fix, but am unsure how to do it. At the end of the recording of the macro, I hit the right arrow 3 times to move over 3 cells across. The problem is that the macro recorded it as follows: Range("F834").Select How do I change that line from an absolute reference to a relative one so that the cell I am on is 3 to the right? Thanks, Ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro lookup columns | Excel Discussion (Misc queries) | |||
| Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
| insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
| macro to unmerge columns | Excel Discussion (Misc queries) | |||
| Macro for resizing of columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
