Highlighting column and row headers using VBA

[Bonnister]

Hello people

I have a task in vba I'm trying to do and failing badly at so all help is appreciated as ever!

I've attached an Excel file detailing what I'm looking for, I basically need some code that will highlight the row and column titles based on the cell that has been clicked on. Can anyone help please?

Many thanks
Kenny

[AB33]

"cell that has been clicked on"?
which column, or you wish to click on?

[Bonnister]

Hi , i attached the wrong file to my original post but I've just uploaded the correct one which should make the question clearer! In the attached file, the range C3:J12 will be a named range for the VBA code to reference, if I then click on any cell within that named range (so for example, E8) the corresponding header in row 2 and the factor in column B will be highlighted

[JOHN H. DAVIS]

Hi , i attached the wrong file to my original post but I've just uploaded the correct one which should make the question clearer! In the attached file, the range C3:J12 will be a named range for the VBA code to reference, if I then click on any cell within that named range (so for example, E8) the corresponding header in row 2 and the factor in column B will be highlighted

Is there supposed to be another attachment?

[JieJenn]

I was thinking of Conditional formatting, but it was too much thinking so I went with VBA

Please Login or Register  to view this content.