Shortcut keys for empty cell at end of range

**tigertim71** · 07-04-2009, 09: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** · 07-04-2009, 09:37 PM

Code:

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

will take you to the first empty cell after the last entry in column a

**tigertim71** · 07-05-2009, 06:04 AM

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

**martindwilson** · 07-05-2009, 06:37 AM

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** · 07-05-2009, 06: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** · 07-05-2009, 06:52 AM

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

**martindwilson** · 07-05-2009, 06:54 AM

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

**tigertim71** · 07-05-2009, 06: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.

Thread: Shortcut keys for empty cell at end of range

Thread Tools

Display

Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Re: Shortcut keys for empty cell at end of range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions