vba code for multiple columns

[AussieRed]

I have written code that highlights the entire row, but what I want to do is highlight column A - C, skip D then highlight the active column (which will be either E,F, or G). This must happen using a variable for the row number, as not every row needs to be highlighted.

 

[Andrew Poulsom]

Post your code and specify the condition which must be satisfied for the row to be highlighted.

 

[philR]

if I understand your question, this should do the trick :

Sub test()
myCol = Selection.Column
myColStr = Chr$(myCol + 64)
myRow = 5 '****** Put your row variable here. If you want it to be the current row,
'****** use myRow=selection.row
Range("A" & myRow & ":C" & myRow & "," & myColStr & myRow & ":" & myColStr & myRow).Select
End Sub

Phil