Select cell based on the last entry in other column

**Kehjz** · 01-26-2013, 01:14 PM

2013-01-27 01_08_44-Microsoft Excel - Book1.png 2013-01-27 01_08_44-Microsoft Excel - Book1.png

Hi all,

I'm sorry if this has been asked before, I'm no expert in any sort of VBA, and my only VBA come via macro record. This is the code I have currently:-

Please Login or Register  to view this content.

How do I change the way the macro select based on the last entry in column A, instead of only selecting cell to only B21?

Thanks a lot.

**Norie** · 01-26-2013, 01:18 PM

What cell do you actually want to select?

If it's the last entry in column A.

Please Login or Register  to view this content.

If it's the cell in column B that is on the same row as the last entry in column A.

Please Login or Register  to view this content.

**Kehjz** · 03-03-2013, 11:34 AM

Hey Norie,

Thanks a lot for the help, I'm using this right now.

Please Login or Register  to view this content.

**Norie** · 03-03-2013, 11:46 AM

And it's working?

**Kehjz** · 03-03-2013, 11:50 AM

Yes Sir, it's working. I copied it to a notepad. Every time I record a macro, I will simple copy and replace the one that part where I need auto fill.

I don't read understand all these coding so I just record those things I do every time to make my job easier.

**arlu1201** · 03-03-2013, 02:44 PM

Kehjz,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.