ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   paste to next blank cell/row (https://www.excelbanter.com/excel-worksheet-functions/93073-paste-next-blank-cell-row.html)

Yvette

paste to next blank cell/row
 
Hi ppl

Using code, can anyone help with the correct code for copying a range of
cells and pasting them to another sheet that already contains data in same
range.

Is there a Count that will source out the first blank cell in a given column
then paste at that point.

TIA

Yvette



Marcelo

paste to next blank cell/row
 
Hi Yvete,

try this tipo on the Ron page.

http://www.rondebruin.nl/copy1.htm

Hope it helps.
regards from Brazil
Marcelo

"Yvette" escreveu:

Hi ppl

Using code, can anyone help with the correct code for copying a range of
cells and pasting them to another sheet that already contains data in same
range.

Is there a Count that will source out the first blank cell in a given column
then paste at that point.

TIA

Yvette





All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com