find next used cell

UALynn · Mar 30th, 2004, 02:23 AM

Awright, I'm just getting frustrated here.

I want to start in cell A1 and working my way down the column locate the next used cell.

So if cells A3, A7, and A98 have data my psuedo code would be like

The data looks like
Col A ColB
Test
data
data

Another
more
more
more

And
more again

sorry the post didn't space things as expected

I know how to use offset.
I have tried using .end(xldown) to get to the next data point in column A, but I keep getting unexpected results.

Mar 30th, 2004, 02:23 AM	#1
UALynn Join Date: Mar 2004 Posts: 15	find next used cell Awright, I'm just getting frustrated here. I want to start in cell A1 and working my way down the column locate the next used cell. So if cells A3, A7, and A98 have data my psuedo code would be like The data looks like Col A ColB Test data data Another more more more And more again sorry the post didn't space things as expected I know how to use offset. I have tried using .end(xldown) to get to the next data point in column A, but I keep getting unexpected results.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode