Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CTRL+R Fill Right
I think I overwrote the Microsoft Shortcut Fill Right by assigning another
macro to CTRL+R. I can't find the macro to delete it. Does anyone have the code behind Fill Right? I'm thinking I should be able to place it in my "Personal" workbook, assign it the option of CTRL+R. If not, I'm basically looking to copy formulas to the right, to the end of my rown (formulas are already there, just want to overwrite what I have) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CTRL+R Fill Right
On Thu, 8 Mar 2007 07:15:45 -0800, StephanieH
wrote: I think I overwrote the Microsoft Shortcut Fill Right by assigning another macro to CTRL+R. I can't find the macro to delete it. Does anyone have the code behind Fill Right? I'm thinking I should be able to place it in my "Personal" workbook, assign it the option of CTRL+R. If not, I'm basically looking to copy formulas to the right, to the end of my rown (formulas are already there, just want to overwrite what I have) Open the macro dialog (Alt-F8) and go down the macros one-by-one and click on the Option button to see which has that assignment. Try to replicate Excel's built-in features is a fool's errand. However, If Typename(Selection) = "Range" Then Selection.FillRight End If -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
Redefining the Ctrl [ and Ctrl ]s short cut with OnKey? | Excel Programming | |||
Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming |