I would like data to be pasted into the next empty cell within a range. A1:C10
I know how to find the last empty cell in a row or column, but how do i find it within a range.
e.g.
Range = A1:C10
Start transfer at A1 then down to A10, then b1>B10, then C1>c10
Is it easier if I named the range something first?
thanks in advance.
Bookmarks