Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've been trying to make a minor edit to a simple XLM macro which I
wrote many years ago. On running the macro from any cell it should select the cell in col B of the same row. FWIW, this shows the worksheet MACROGEN-3.XLM after unhiding it. https://dl.dropboxusercontent.com/u/...lSameRow-1.jpg I thought I could now edit it from GotoColA =COLUMN(ACTIVE.CELL()) =SELECT("rc["&-(ColA-1)&"]") =RETURN() to this GotoColB =COLUMN(ACTIVE.CELL()) =SELECT("rc["&-(ColB-1)&"]") =RETURN() But, without going into detail, I failed on several counts. So I'll abandon that; even though many of those old macros appear to work, it seems pointless to attempt to maintain or edit them. Could I therefore get some help on a modern VBA macro to do it please? Which presumably I should insert in PERSONAL.XLS (or PERSONAL.XLSM if I rename it as I intend.) -------------------- I did look for a KB shortcut and also tried using the GoTo dialog, but failed there too. -- Terry, East Grinstead, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create multi choice selec drop down list in Excel please | Excel Discussion (Misc queries) | |||
Selec the column to add in a listbox | Excel Programming | |||
Macro to capture cell value then use it for a relative range selec | Excel Programming | |||
A recorded Macro to hide certain selected columns hides non selec. | Excel Programming | |||
To have an entire row highlighted to some color if any cell in that row is selec | Excel Programming |