I have a workbook in which I run a macro whose job is to clean up.
the macro deletes a column with information and then cut and paste the other information so everything moves forward and the last column is clean.
everything runs as it should until someone deletes a row.
I now want to add a row but using the macro. In other words, the rows must be fixed for the macro to work.
Please Help me, this is the code.
Range("C4:C65").Select
Selection.ClearContents
Range("D4:U65").Select
Range("U4").Activate
Range("D4:U65").Cut Destination:=Range("C4:T65")
Range("T4:T65").Copy Destination:=Range("U4:U65")
Range("B3").Select
it's a loop that needs one more feature.
Bookmarks