SelectionChange

[russkris]

Hello,

I have found the below VBA code and it works a charm.

Please Login or Register  to view this content.

However, I have column headings that are shaded, and the above removes all shading from the worksheet. Which part do I need to modify to allow the top few rows to have their own colours? Rows 1:10 have heading(filled with colour) and picklists

[davesexcel]

Looking at your code, it appears you want to Highlight the Row and Column of the active cell.

Although this is a cool function, there are undesired results.

This only works best if no other cells have formats that you want to keep, even copy and paste will not work for this.

[russkris]

Thank you so much for your reply, so I am guessing there is no work around for this?

[davesexcel]

That is a good assumption.

[russkris]

Bugga... Thank you very much for taking the time to reply and edit my post, will remember code tags not quote tags next time

[russkris]

Bugga... Thank you very much for taking the time to reply and edit my post, will remember code tags not quote tags next time