Here is yet another way...

Range("A1:F1").Offset(ActiveCell.Row - 2).Select

--
Rick (MVP - Excel)


"peyman" wrote in message
...
hi,
How can I write a code in a way to select the range A to F columns one row
less than active cell row no. . For example if the activecell address is
D3
the range will be selected like A2:F2.
Thanks for your help.