VBA help - how to select column after next

[Dannyh1]

Hi,

I want to select Range A1:A100 & Range C1:C100

Could anyone please advise code to do this?

Many Thanks
Danny.

 

[JackDanIce]

Try:

Range("A1:A100,C1:C100").Select

 

[VoG]

Try

Sub Slect()
Range("A1:A100,C1:C100").Select
End Sub

 

[Andrew Poulsom]

A couple of ways:

Range("A1:A100,C1:C100").Select
Union(Range("A1:A100"), Range("C1:C100")).Select

 

[Misca]

Range("A1:A100,C1:C100").Select

 

[Dannyh1]

Sorry didn't explain myself!

It will not always be A1:100, it could A1:A50 , then I would want A1:A50 & C1:C50

I know how to use offset, but I want to miss out column B.

Thanks again

 

[VoG]

Try

Sub Slect()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
Range("A1:A" & LR & ",C1:C" & LR).Select
End Sub

 

[Dannyh1]

Perfect thank you Peter