View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default 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