Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative References for macros
I seem to need a lot of help for coding when I can't use record macro to
figure out certain things, particularly things that involve relative movements within a worksheet. Somewhere in my very distant past, perhaps with LOTUS, I seem to recall there was a way to record so that it would record the relative changes (like going down 100 rows) rather than going from row 4 to 104. Is there still such a capability with EXCEL macros. If so, will it do the things I am thinking of? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative References for macros
Hi
you could also set this option for recording macros. Another way is using offset. e.g. activecell.offset(100,0).select -- Regards Frank Kabel Frankfurt, Germany Grace wrote: I seem to need a lot of help for coding when I can't use record macro to figure out certain things, particularly things that involve relative movements within a worksheet. Somewhere in my very distant past, perhaps with LOTUS, I seem to recall there was a way to record so that it would record the relative changes (like going down 100 rows) rather than going from row 4 to 104. Is there still such a capability with EXCEL macros. If so, will it do the things I am thinking of? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative References for macros
The stop recording toolbar has a button that toggles relative and absolute
recording. -- Regards, Tom Ogilvy "Grace" wrote in message ... I seem to need a lot of help for coding when I can't use record macro to figure out certain things, particularly things that involve relative movements within a worksheet. Somewhere in my very distant past, perhaps with LOTUS, I seem to recall there was a way to record so that it would record the relative changes (like going down 100 rows) rather than going from row 4 to 104. Is there still such a capability with EXCEL macros. If so, will it do the things I am thinking of? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative References for macros
I know I've seen it before but I cannot find this toolbar. Kindly tell me
how to access it. Grace "Tom Ogilvy" wrote in message ... The stop recording toolbar has a button that toggles relative and absolute recording. -- Regards, Tom Ogilvy "Grace" wrote in message ... I seem to need a lot of help for coding when I can't use record macro to figure out certain things, particularly things that involve relative movements within a worksheet. Somewhere in my very distant past, perhaps with LOTUS, I seem to recall there was a way to record so that it would record the relative changes (like going down 100 rows) rather than going from row 4 to 104. Is there still such a capability with EXCEL macros. If so, will it do the things I am thinking of? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative References for macros
Start recording and it should appear. If it doesn't, start recording, then
go to View=Toolbars and select the stop recording toolbar. Now click the stop button. The toolbar should disappear, but should reappear if you start recording again. Avoid clicking the little x in the upper right of the toolbar to make it disappear - once you do, you will have to repeat the above to get it to appear again. -- Regards, Tom Ogilvy "Grace" wrote in message ... I know I've seen it before but I cannot find this toolbar. Kindly tell me how to access it. Grace "Tom Ogilvy" wrote in message ... The stop recording toolbar has a button that toggles relative and absolute recording. -- Regards, Tom Ogilvy "Grace" wrote in message ... I seem to need a lot of help for coding when I can't use record macro to figure out certain things, particularly things that involve relative movements within a worksheet. Somewhere in my very distant past, perhaps with LOTUS, I seem to recall there was a way to record so that it would record the relative changes (like going down 100 rows) rather than going from row 4 to 104. Is there still such a capability with EXCEL macros. If so, will it do the things I am thinking of? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative References for macros
Excellent!
"Tom Ogilvy" wrote in message ... Start recording and it should appear. If it doesn't, start recording, then go to View=Toolbars and select the stop recording toolbar. Now click the stop button. The toolbar should disappear, but should reappear if you start recording again. Avoid clicking the little x in the upper right of the toolbar to make it disappear - once you do, you will have to repeat the above to get it to appear again. -- Regards, Tom Ogilvy "Grace" wrote in message ... I know I've seen it before but I cannot find this toolbar. Kindly tell me how to access it. Grace "Tom Ogilvy" wrote in message ... The stop recording toolbar has a button that toggles relative and absolute recording. -- Regards, Tom Ogilvy "Grace" wrote in message ... I seem to need a lot of help for coding when I can't use record macro to figure out certain things, particularly things that involve relative movements within a worksheet. Somewhere in my very distant past, perhaps with LOTUS, I seem to recall there was a way to record so that it would record the relative changes (like going down 100 rows) rather than going from row 4 to 104. Is there still such a capability with EXCEL macros. If so, will it do the things I am thinking of? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Excel 2003 macros set relative cell references | Excel Discussion (Misc queries) | |||
Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
Relative Cell References in Macros | Excel Programming |