Paste last row

[Maxlond]

Hey,
I have a problem with the macro fragment that pastes data into Excel to me always from row A1 and I would like it to be pasted after the last filled line (sometimes the excel file is empty and sometimes it already contains some data). I have a request for help.

Please Login or Register  to view this content.

[MarvinP]

Hi Maxlond,

You need a LastRow = Cells(Rows.Count,"A").End(xlUp).Row
and then
Cells(LastRow + 1, "A").Select

The above replaces your Range("A1").Select

[Maxlond]

Thanks but sometimes the data in Excel does not end in column A and between column A and column F. A in this case sticks to the completed row.

[MarvinP]

Now I'm a little worried if your data looks differently based on what sheet you are working on.

You might try "UsedRange" but if you have extra data on the worksheet this might not work either. See:

https://www.automateexcel.com/vba/fi...w-column-cell/