Just a simple one I guess.
I am trying to write a macro that will change the background of the current row, and increase the value of a cell by 1. I have hit a stumbling block though as my code (below) actually colours the row a few lines down. And If it's not column A selected, the coloured cells will be shifted over.
What I want is to be able to select say any cell row 7, then A7:K7 will turn colour.
Thanks guys.
I am trying to write a macro that will change the background of the current row, and increase the value of a cell by 1. I have hit a stumbling block though as my code (below) actually colours the row a few lines down. And If it's not column A selected, the coloured cells will be shifted over.
What I want is to be able to select say any cell row 7, then A7:K7 will turn colour.
Code:
ActiveCell.Range("A" & ActiveCell.Row(), "K" & ActiveCell.Row()).Interior.ColorIndex = 8Thanks guys.