I am selecting a range of cell into which I paste data. I want to paste the data from the top cells selected, down to the last empty cell in the column. The code I am using looks like this, but this paste the data from the selection down into the first cell containing data, overwriting my first row of existing data.
I tried to offset the range using the code below, but it offsets the TOP of the range, rather than the bottom, so the paste overwrites my column headings.
I'm sure this is an easy one for you guys. Please help.
Thanks in advance.
Jerry
Bookmarks