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)

On Thu, 8 Mar 2007 07:15:45 -0800, StephanieH
<(E-Mail Removed)> 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