macro - cell selection

[taiariol]

please help ....

Range("C1313").Select

how do I select 2 adjacent cells interms of a target row??

Range("target.row, "c":target.row, "d"").select

something like that???

 

[J.E. McGimpsey]

One way:

Cells(Target.Row, 3).Resize(1, 2).Select

or

Range("C" & Target.Row).Resize(1, 2).Select

or

With Target
Range("C" & .Row & "" & .Row).Select
End With

 

[Leo Heuser]

Here are two ways to do it:

Cells(Target.Row, "C").Resize(1, 2).Select

Range(Cells(Target.Row, "C"), Cells(Target.Row, "d")).Select

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.

 

[May]

Range("A" & LASTROW & ":L" & LASTROW).Select

 

[Guest]

this works! thank you very much!

-----Original Message-----
One way:

Cells(Target.Row, 3).Resize(1, 2).Select

or

Range("C" & Target.Row).Resize(1, 2).Select

or

With Target
Range("C" & .Row & "" & .Row).Select
End With



.