Say there is a macro written for A line of cells.. Is there a way to shift the entire macro down one cell? say it does something to A5 To F5 .. then it should go down to A6 to F6 and all the values in the macro should change by 1. Is it possible or do i need to make a lets say.. Dim K as Range.. and do it that way..
Bookmarks