ActiveCell

[Dysprositos]

Hi

How can i select the cells B:J,M:N,T in the active row?

So far i have
ActiveCell.Offset(0, -12).Activate

this selects the B cell in the active row. How can i select more than one cell?

Should i explain more, this seems pretty confusing...


cheers

 

[Mark O'Brien]

Something like this would work:

<pre>
Public Sub main()

Dim iRow As Long
Dim sSelections As String

iRow = ActiveCell.Row
sSelections = "B" & iRow & ":J" & iRow & ",M" & iRow & ":N" & iRow & ",T" & iRow
ActiveSheet.Range(sSelections).Select

End Sub</pre>

 

[Dysprositos]

Thats awesome! Thanks

Its times like these that make me want to enrol in some kind of visual basic tafe course or something.

Cheers

 

[Mark O'Brien]

A library card is a cheaper investment. Flick through as many VBA books as they have. You don't need to read the whole book, just look for the interesting bits.