Draw a horizontal line across a range when column value changes.

Hi,

Thanks Mumps, that works well. Just one problem - If i then change the information in the cells and re-run the macro, the horizontal lines from the previous macro are not removed, just new ones added.....is there a way to amend so it changes them back to your standard thin black line?

Hi Mumbles

That very nearly works, when i first run it, it puts the dashes in perfectly but then puts the normal thin lines outside the range (B6:BJ500), then when i run it again with values removed in the column G, it puts the thin lines back in correctly, but again I presume its re-drawing the lines outside the range..... Please note i changed the bold from your above code as it was drawing no lines

Please Login or Register  to view this content.

Ah sorry. My bad. However as per your original code it removes all lines on the sheet (horizontal and vertical) except the dashed ones, which are correct.

What would ideally happen is:

1) Values are entered in column G.
2) The macro runs and horizontal dashed lines are inserted in the range (B7:BJ500) where the values change in column G. (this worked in your original response).
3. I'd then like to be able to remove the values in column G, run the macro and have the lines revert back to standard thin black lines (ie before the macro was run).
4) This must only happen in the range (B7:BJ500)

Does this help. Thanks for your patience.

Hi,

No cells G1:G5 have information in them - well G5:G6 do, the others are empty....

Mumble, you're a star, thank you so much for that