Copy each cell until empty value

dmdek

New Member
Joined
May 3, 2011
Messages
4
Copy someone please help me understand how to cells values looping through a range.

I am trying to take range a range in sheet 1 column A and and copy each cell and pasting the value into sheet 2 cell B5...after it paste the workbook recalculates and I will copy and paste a set range from sheet 2 to a 2nd file and then begin the loop again...

The part I am having trouble with is understanding how to select the cells in my range on sheet 1 and then move to the next cell.

Thank you in advance.

Dan
 

doubledaffy

Board Regular
Joined
Jan 22, 2010
Messages
172
Try exploring the Range.End function in excel. If you figure it out, it will allow you to select a range of cells and copy them.
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top