Copy each cell until empty value

[dmdek]

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]

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.