I would like to select a split range to apply formatting with a macro
eg: Range(A1:B9, H1:J9)
My problem is that my current code selects all cells inbetween
eg: Range(A1:J9)
This is the line in question ...
Looking forward to your suggestions
eg: Range(A1:B9, H1:J9)
My problem is that my current code selects all cells inbetween
eg: Range(A1:J9)
This is the line in question ...
Code:
' Define Report Area to be formatted
Set FormatRng = Range(Range(Cells(Equal.Row, Equal.Column), Cells(Equal.Row + RowCount, Equal.Column)), _
Range(Cells(NotEqual.Row, NotEqual.Column), Cells(NotEqual.Row + RowCount, NotEqual.Column)))
Looking forward to your suggestions