Deselect Range

[Dannyh1]

Hi,

I have the following code

Range(Selection, Selection.Offset(0, 9)).Select

I colour this Range & then I want to go back to the 1st column in Range

I tried below, but this errors

    Range(Selection, Selection.Offset(0, -9)).Select

Help appreciated.

Thanks

 

[JackDanIce]

It's better to never use '.Select' or '.Activate' in your code whenever possible. Can you post your whole code please - there may be another way to achieve what you want..

 

[jasonb75]

You don't need to select it to change the cell colour.

With Range(Selection, Selection.Offset(0, 9))
    .Interior.ColorIndex = 1
End With

Note, replace the red with your own colour change code.

 

[VoG]

But if you did want to select, how about

Selection.Resize(, 1).Select

 

[Dannyh1]

Excellent - this works.

Thanks chaps.