For Excel Macro - what is code for move to last empty row and pastesomething

J

John

Hi

I'm working through some huge Excel spreasheets.

The first thing I do is press Control-F and seek '12345' to look for a
given row.

Once I get to that row, I basically press 'tab' until I reach the
final row of 'white space'. It's easy, if a little mundane, to do it
by sight.

---> Is there code that can do this bit?

Thanks very much!
 
D

DBDeveloper

Hi

I'm working through some huge Excel spreasheets.

The first thing I do is press Control-F and seek '12345' to look for a
given row.

Once I get to that row, I basically press 'tab' until I reach the
final row of 'white space'. It's easy, if a little mundane, to do it
by sight.

---> Is there code that can do this bit?

Thanks very much!

End+DownArrow in any column takes you to the last entry in that column
 

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

Top