Modify Highlight Row Script/Code

This is surely simple - just want to change this to highlight all rows of selected cells instead of just the one row.

Please Login or Register  to view this content.

So currently if cursor is on sat A1 it will highlight all of A1 (to the end of data) - I want to be able to say, select A1 through A4 and then it highlight Rows 1-4 (to the end of data only)

Thanks in advance

Originally Posted by NewYears1978

.... (xlDialogEditColor) ....
lcolor = ActiveWorkbook.Colors(10)

But it is not coloring cells, just a modification of the excel color palette (Tools\Options\Color\Modify).
To modify the color of the cell(-s) all you need is select cells range and this:

Please Login or Register  to view this content.

It's just my opinion, I can be wrong ... (?)

First two options worked Thanks!