VBA help

[huat]

Hi, I have this table that I would like to use VBA to select for each row the last available column K or L. I tried to record a VBA but when the active cell is at A2, I pressed Ctrl and right arrow keys, it will go to N2. I had actually wanted to go to L2 so that I can select L2 and copy to paste to another worksheet. But when the active cell is at A3, pressing Ctrl and right arrow keys will go to K3 instead of N3, which is what I wanted. Pls help. Thanks.

 

[Zot]

The reason it went to N2 instead of L2 perhaps because you probably has a space in M2. Try Del anything in M2.

Even if you have VBA, how do you want to initiate action to go to last column with data? You can just easily use Ctrl+Arrow Right

 

[huat]

The reason it went to N2 instead of L2 perhaps because you probably has a space in M2. Try Del anything in M2.

Even if you have VBA, how do you want to initiate action to go to last column with data? You can just easily use Ctrl+Arrow Right

Thanks Zot for your reply. I'm away from office now. I will see if there's really something there in M2 tomorrow. I'm using VBA because I will need to copy the last column of the data every month and paste it to another worksheet, so wanting to automate it to save time. Thanks

 

[Zot]

Thanks Zot for your reply. I'm away from office now. I will see if there's really something there in M2 tomorrow. I'm using VBA because I will need to copy the last column of the data every month and paste it to another worksheet, so wanting to automate it to save time. Thanks

Yes. I'd automate if it is repetitive routine even monthly but in order to get helpers' help here you need to provide how your data source and destination sheet laid out.

 

[huat]

I've deleted the space at M2 and the problem is now solved. Thanks.