next blank line
The first copy and paste i do works(but still strts pasting from column A),
but when i add a second set of code exactlly the same, but a different source
it copys over the first data set instead of going to the next line.
"Mike H" wrote:
Hi,
This finds the cell below the last entry in column A
Lastrow = Cells(Cells.Rows.Count, "a").End(xlUp).Row + 1
If you don't know hich column the last used row is in then use this
LastRow = UsedRange.Rows.Count + 1
Mike
"Miree" wrote:
I have some code which copies and pastes for a few differnet places how can i
paste from the next blank row
|