I've been looking all over and trying to adapt codes and I'm striking out on this.
On my worksheet, I want to insert a named range above an active cell. So I have lots of named ranges, and when I select a cell, I want to be able to run a macro that inserts a named range above. it could be one line, it could be 20 lines. I've recorded macros where I manually copy the range, then go to the active cell and insert the copied cells above, moving the existing rows down, but I cant figure out how to adapt this to the activecell property (If that's even what I should be doing).
Here's a recorded macro where I copy a range, than insert it and move the selection down. But I want this to be done with a macro.
It could be one macro per named range, but what would be really nice is if there was a drop down with all of the available named ranges as well that popped up when the macro ran. Otherwise I would have to make a separate macro for each range which would be fine too
Thank you!
On my worksheet, I want to insert a named range above an active cell. So I have lots of named ranges, and when I select a cell, I want to be able to run a macro that inserts a named range above. it could be one line, it could be 20 lines. I've recorded macros where I manually copy the range, then go to the active cell and insert the copied cells above, moving the existing rows down, but I cant figure out how to adapt this to the activecell property (If that's even what I should be doing).
Here's a recorded macro where I copy a range, than insert it and move the selection down. But I want this to be done with a macro.
VBA Code:
Sub Macro3()
'
' Macro3 Macro
'
'
Sheets("OPTIONS").Select
Application.Goto Reference:="INTERNAL_BELOWHOOPS"
Application.CutCopyMode = False
Selection.Copy
Sheets("MAIN").Select
Rows("201:201").Select
Selection.Insert Shift:=xlDown
End Sub
It could be one macro per named range, but what would be really nice is if there was a drop down with all of the available named ranges as well that popped up when the macro ran. Otherwise I would have to make a separate macro for each range which would be fine too
Thank you!