Hello all
How can I select a range with an expanding Last Row, I have tried with the code below but it is not working
Once the range is selected it calls two macro for borders and colours
How can I select a range with an expanding Last Row, I have tried with the code below but it is not working
Once the range is selected it calls two macro for borders and colours
Code:
LR = Range("C" & Rows.Count).End(xlUp).Row
Range("C16:AA" & LR).select
AddOutsideBorders
Colour1
Last edited: