Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert old macros
I have workbooks with old macros recorded using relitive references. I run
some each month and new data is apended after the old data and then sorted. When I record in excel 2003 I do not get the choice and all copy paste or sorts have cell addresses. Is there an easy way to convert? Eg. =SORT(1,"R12C67",2,"R12C71",2,"R12C68",1) converts to Selection.sort Key1:=Range("bo12"), Order1:=xlDescending, Key2:=Range("bs12") , Order2:=xlDescending, Key3:=Range("bp12"), Order3:=xlAscending, Header :=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom , DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= xlSortNormal And , =FORMULA.GOTO("R200C3") converts to Range("C200").Select BUT HOW DO I CONVERT; =SORT(1,"RC",2,"RC[1]",1) and, =SELECT("R[1]C[-1]:R[16]C[1]") -- TJLV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Lotus Macros do not convert to Excel | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |