Find next blank cell via macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing a macro that will cut and paste data from different tabs and
aggregate it onto a new sheet. I would like to know the best way to search
the new sheet to find the next blank cell via a macro after data has been
pasted so I can have the macro cut and paste the next portion of data
automatically. Hopefully this makes sense. Thanks, Eric.
 
Just a comment on Ron's function here, the reason this works so well is that
it will find the last used row even if that row is hidden.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what VBA command is used to go to the next blank row in Excel? 4
Ignoring a blank cell while running a macro. 1
Create if partial match then copy and paste data from one cell to another 1
Find next blank column with Macro 9
Cutting row data and pasting into next available row on different tab 2
macro program 3
macro to copy data and paste to a new sheet in next available cell 2
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4

Back
Top