There's a number of threads on here regarding how to incorporate the use of the "INDIRECT" function withina macro, but all answers quickly go over my head and i'm unable to translate to my particular problem. All of the cells referred to in the below macro, for me need to NOT change whether or not rows are inserted or deleted above row 58 (as they most certainly will).
IN my simple excel formula mind, I want to just put "Rows (INDIRECT("$58:$58")).Select", and repeate throughout. That obviously won't work.
Any help/suggestions are appreciated.
Thanks!
Sub Add3Rows_Renal()
'
' Add3Rows_Renal Macro
'
'
Rows("$58:$58").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("$C$58:$I$58").Select
Selection.AutoFill Destination:=Range("$C$58:$I$58"), Type:=xlFillDefault
Range("$C$58:$I$58").Select
Range("$D$58:$E$58").Select
Selection.ClearContents
Range("$G$58").Select
Selection.ClearContents
Range("$C$61").Select
Selection.AutoFill Destination:=Range("$C$58:$C$60"), Type:=xlFillDefault
Range("$C$58:$C$60").Select
Range("C58").Select
End Sub
Bookmarks