Try
Dim Rng As Range
Set Rng = Application.Union(Cells(ActiveCell.Row, "A").Resize(,
3), _
Cells(ActiveCell.Row, "F"))
Rng.Select
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Cumberland"
wrote in
message
...
Hi!
Could anyone tell me how I can select columns A, B, C, and F of
the
active cell's row?
Thanks.
--
Cumberland
------------------------------------------------------------------------
Cumberland's Profile:
http://www.excelforum.com/member.php...o&userid=33445
View this thread:
http://www.excelforum.com/showthread...hreadid=556393