Macro that will find the next empty row in a table

**Anon415** · 11-13-2012, 04:15 PM

Hi...I am currently working on a budgeting project and need to copy data from one worksheet to the first available row on the main data worksheet. All of the data on the main worksheet is listed in a table. I have found a code that will take me to the first empty row, however the row it is locating is the first empty row after my table. I need the code to find either the first empty row in the table or the last populated row in the table. Unfortunately there are various blank cells throughout the table. This is what I currently have.

Please Login or Register  to view this content.

**young_86** · 11-13-2012, 04:34 PM

I think it will be easier if you add

**Anon415** · 11-13-2012, 04:45 PM

Add what? I'm new to working with macros, just began working with them a few weeks ago.

**young_86** · 11-13-2012, 05:57 PM

sorry for mistake.
I think it will be easier if you add excel file.

ps.i'm a begginer to, but his forum is awesome, you can find many interesting information and users are amazing. I hope You'll find answer for Your problem.

**Anon415** · 11-15-2012, 09:49 AM

Thank you! Unfortunately I cannot add the file because it contains confidential information. I'm not sure if I can possibly name my table as a specific range and then put in a code that will go to the first empty row within that specific range. I'm sure there is a way to do this, just need a little help!!!