paste_range.count = 262Set paste_range = ThisWorkbook.Worksheets("Curve Fitter").Range("C14:C" & cell_count + 13) iRow = 0 For Each ccell In copy_range iRow = iRow + 1 copy_array(iRow) = ccell.Value Next ccell paste_range = copy_array
ubound(copy_array) = 262
so they should have the same count
but when I perform the paste operation, it pastes the first entry of copy_array into every cell of paste_range
why isn't it pasting each unique value into the worksheet range?
Bookmarks