Shortcut keys for empty cell at end of range

tigertim71 · #1 07-04-2009, 08:11 PM

I'm trying to record a macro and select the first empty cell at the bottom of a range of numbers, eg. A1,A2,A3 (populated), A3 (empty).

I think it's ctrl+ or alt+ (something). Whatever I'm trying isn't working...

martindwilson · #2 07-04-2009, 08:37 PM

Code:

Sub findbottom()
Range("A65536").End(xlUp).Offset(1, 0).Select
End Sub

tigertim71 · #3 07-05-2009, 05:04 AM

OK, thanks. But I was hoping to use the keyboard rather than write code at this stage...

martindwilson · #4 07-05-2009, 05:37 AM

Quote:

I'm trying to record a macro

just record the macro but manually select first empty cell at end of column when everything is done replace the line that says say A1234 .select with Range("A65536").End(xlUp).Offset(1, 0).Select
but there isnt a direct short cut key ctrl +down arrow takes you to the last used cell.

tigertim71 · #5 07-05-2009, 05:51 AM

Sorry, I didn't make this clear. I was just hoping for a keyboard selection irrespective of whether I'm recording a macro or not, ie. I'd like to see the first empty cell after my range selected on screen, using crtl+ or alt+, if this is possible.

tigertim71 · #6 07-05-2009, 05:52 AM

Sorry, Ignore previous message - if there isn't a shortcut key, too bad...

martindwilson · #7 07-05-2009, 05:54 AM

ctrl +down arrow takes you to the last used cell. how close do you want to get.?
use down arrow again

tigertim71 · #8 07-05-2009, 05:41 PM

This makes perfect sense now. I had mistakenly thought there was a function for this in Excel, but I can work my way around this without a problem.

Welcome to the Excel Forum

Forum Statistics