(Solved) – how to select specific cell to next one after the cell filled

(solved)-–-how-to-select-specific-cell-to-next-one-after-the-cell-filled

I would like to specify my excel to go on my special cells. I mean when the first cell should be S5, and when this filled go to C6, then to C11, E11, G11, I11, K11, M11, O11, Q11, S11, then C12 E12……..same method till s34 then goto H36.

I am try to use this:

If Not IsEmpty(Range("$C$11:$Q$11").Value) Then ActiveCell.Offset(0, 1).Select

Unfortunately in this case the active cell go 1row down and one column right, and use not only the specified range. I am not ggon in Excel macro pls help! Thx in advance!

Leave a Reply

Your email address will not be published. Required fields are marked *