I am trying to select a range called A1item2 which is A15:AK15 then insert a specific number of cells, shifting existing cells down. When I record, I get this:
Application.Goto Reference:="A1Item2"
Range("A15:AK21").Select
Selection.Insert Shift:=xlDown
But of course, it is recording the actual address of cells being selected to insert down. Anyone have any ideas?
Application.Goto Reference:="A1Item2"
Range("A15:AK21").Select
Selection.Insert Shift:=xlDown
But of course, it is recording the actual address of cells being selected to insert down. Anyone have any ideas?