Select multiple but non sequential cells relative to a particular

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi Folks,

I need to be able to Select a number of different cells and copy them.
They are non sequential.
BUT
I need to select them relative to another cell.

I'm using a case statement to say if b3 = 1 then copy cells G, I & K on
that same row. I can't be specific with the row number as I need to repeat
this process on multiple lines.

Any ideas??

Cheers
 
You can do something like this

MyRow = Range("B3").Row
cells(MyRow,"G").copy
cells(MyRow,"I").copy
cells(MyRow,"K").copy
 

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

Excel Sequential Numbering System 0
Code for multiple select of cells 16
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
copy multiple rows 9
How to Select A Cell in VBA with a Variable Row Number? 3
Relative Ranges - Multiple Cells 1
Copy a range data from 1 sheet to multiple selected sheets 1
copy non adjacent cells 0

Back
Top