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.