I am a newbie to VBA using Excel 2010. I want Excel to (1) copy cells B:H of the active row, (2) insert one row below the active row, and (3) paste the values of the recently copied cells into the new blank row.
So far, the only knowledge I have gathered allows me to simply copy the entire active row and paste that below using...
ActiveCell.EntireRow.Select
Selection.Copy
Selection.Insert shift:=x1down
I will appreciate being taught how to only copy certain cells of active row to paste below. Thank you.
So far, the only knowledge I have gathered allows me to simply copy the entire active row and paste that below using...
ActiveCell.EntireRow.Select
Selection.Copy
Selection.Insert shift:=x1down
I will appreciate being taught how to only copy certain cells of active row to paste below. Thank you.