christchaaya
Board Regular
- Joined
- Apr 5, 2013
- Messages
- 86
Hello everyone. I'm trying to autofill column a but instead of filling it the macro is deleting the only value in it :S This is the part of the code that should autofill :
I tried it on the inmediate window and it works good till the last row.
Thank you in advance :D
Code:
Range("e2").Copy
Range("a7").PasteSpecial
Range("c" & Cells.Rows.Count).End(xlUp).Select
ActiveCell.Offset(-1, -2).Select
Set x = ActiveCell
Selection.AutoFill Destination:=Range("a7:" & x.Address)
I tried it on the inmediate window and it works good till the last row.
Thank you in advance :D