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