Start Code From Next Blank Row

[cpeck91]

Hi,

I've written this code original just to quickly pull information. Now I want to use it create a database so I don't want the old data to be deleted. I've added in the find last row function but it acts really weird. The first run, the summary is pulled with loads of empty rows. Then next time it finds the empty row no problem. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Thanks and regards
Christian

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[banaanas]

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[BellyGas]

or unusedrow = range("A1048000").end(xlup).row + 1

[cpeck91]

Hi,

Thanks for the response, with these solutions what happens if I get an empty cell A in my data, would that row get overwritten?

Thanks
Christian

[BellyGas]

Yes. To prevent that, use a column that will always have data in it if the row is populated.