See this example

http://www.rondebruin.nl/copy1.htm#ActiveCellrow



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moe" wrote in message ...

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