Hi,
I need to delete part of a column from a set First Row to a set Last Row. I have set these parameters, on this particular sheet it's Row 6 to 17. The column will change from time to time so i need to select a range from the First Row to the Last Row in the column where the activecell sits.
Please can someone advise how to format the code? So far i have tried many options but none work. This was my last attempt
Range(ActiveCell(FirstRow, LastRow)).Select
Thanks
Blunder
I need to delete part of a column from a set First Row to a set Last Row. I have set these parameters, on this particular sheet it's Row 6 to 17. The column will change from time to time so i need to select a range from the First Row to the Last Row in the column where the activecell sits.
Please can someone advise how to format the code? So far i have tried many options but none work. This was my last attempt
Range(ActiveCell(FirstRow, LastRow)).Select
Thanks
Blunder