Hi,
I've used the following formula many times to autofill to the last row based upon the adjacent column
For the code i'm currently writing Column's B & C will always have gaps in their data, therefore it needs to autofill based upon Column A, i've tried various modifications to try and accomplish but without success. Sure it's something fairly simple.
Your thoughts would be appreciated
Thanks
Ben
I've used the following formula many times to autofill to the last row based upon the adjacent column
Code:
Range("D5").AutoFill Destination:=Range("D5", Range("D5").Offset(0, -1).End(xlDown).Offset(0, 1))
For the code i'm currently writing Column's B & C will always have gaps in their data, therefore it needs to autofill based upon Column A, i've tried various modifications to try and accomplish but without success. Sure it's something fairly simple.
Your thoughts would be appreciated
Thanks
Ben