If I am in cell K5, how can I select B5:J5 in order to copy and paste it
somewhere else?
Similarily,
If I am in cell K500, how can I select B500:J500 in order to copy and
paste it somewhere else?

The range I want to copy will always be in the same row as my active
cell and always from columns B to J.

Thanks,
Moe


--
Moe
------------------------------------------------------------------------
Moe's Profile: http://www.excelforum.com/member.php...o&userid=12500
View this thread: http://www.excelforum.com/showthread...hreadid=392979