Copy Range of Cells in Same Row

  • Thread starter Thread starter Moe
  • Start date Start date
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Code- Copy & Paste in Blank Range 9
Help using VLOOKUP command 14
Applying Formulas to a Range in a Worksheet 4
Data Entry Form - Execute if value is not 0 5
Macro copy from range 3
Activating hyperlinks 3
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
VBA Excel partial cell compare to another cell 0

Back
Top