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

[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!

 

[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