Help please.
I need to go to the end of a column and highlight the cell in the forth and fifth row and then only the cell in row 21 of the same column.
Please advise how to write VBA for this. My End Right column changes weekly
Currently I have:
Range("C4").End(xlToRight).Offset(-1, -1).Select (which is the first cell)
I need to include the next cell in row below and the last cell in column which is row 21.
I need to go to the end of a column and highlight the cell in the forth and fifth row and then only the cell in row 21 of the same column.
Please advise how to write VBA for this. My End Right column changes weekly
Currently I have:
Range("C4").End(xlToRight).Offset(-1, -1).Select (which is the first cell)
I need to include the next cell in row below and the last cell in column which is row 21.