Macro for new line location

**rlkerr** · 08-01-2012, 11:24 AM

I'm trying to get my macro to go to the next blank line and tell me what the range number is. Example below the next line would be B795 and I want to put that number in A1.

Please Login or Register  to view this content.

**mike7952** · 08-01-2012, 12:48 PM

Here's a function to get Next Available Row

Please Login or Register  to view this content.

**patel45** · 08-01-2012, 12:51 PM

Please Login or Register  to view this content.

**rlkerr** · 08-01-2012, 01:59 PM

Thank you so much. Just what I needed.

**Cutter** · 08-01-2012, 03:10 PM

@ rlkerr

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.