CTRL+R Fill Right

G

Guest

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)
 
D

Dick Kusleika

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top