Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
causing macros to run at insertion point
When I create Excel macros that cause borders to be set or macros that
include drawings, they only run where they were created. I need to have them run at the point the cursor is at when I execute the macro. In other words, they need to run other places in the worksheet, not just at the cells they were created. How can I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
causing macros to run at insertion point
If you a recording a macro just click on the Relative Reference button
on the Stop Recording toolbar. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
causing macros to run at insertion point
" wrote: If you a recording a macro just click on the Relative Reference button on the Stop Recording toolbar. Your suggestion works for borders and I should have remembered to do that from past use of macros. Thanks because that does help me. Drawing elements still revert to where they were drawn, can macros be created using drawing elements so they too are relative to the cursor cell? Thanks. Dan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
causing macros to run at insertion point
Something like this might work.
Sub Macro3() iTop = ActiveCell.Top iLeft = ActiveCell.Left ActiveSheet.Shapes.AddShape msoShapeRectangle, iLeft, iTop, 219#, 93# End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Point Assessment Calc? | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) |