Copy Range of Cells in Same Row

[Moe]

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

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

Thanks,
Mo

 

[Ron de Bruin]

See this example

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