.Range selecting multiple columns

[twckfa16]

Hello -

I'm using the below to select column A:

With ActiveSheet
              .Range("A" & (ActiveCell.Row)).Select

How do I use this same structure to select Columns B & C ?

I tried this but received an error:

With ActiveSheet
              .Range("B:C" & (ActiveCell.Row)).Select

Thank you!

[AB33]

With ActiveSheet
              .columns("B:C").Select

end with

[twckfa16]

Hi -

I tried that but it is selecting the whole column. So I tried this but also received another error:

.Columns("B:C" & (ActiveCell.Row)).Select

Thanks!

[Norie]

Try this.

With ActiveSheet
    Intersect(.Range("B:C"), .Rows(ActiveCell.Row)).Select
End With

[twckfa16]

Hi Norie -

I just saw this now but I tried this a couple minutes ago and it worked ok:

.Range(("B" & (ActiveCell.Row)), ("C" & (ActiveCell.Row))).Select

Thank you!

[twckfa16]

Norie -

Thank you for that - using yours I was able to select multiple!