searching for a null cell in a column

F

FutureWiz

Any one help me here? I am trying to create a macro/VB that will allow me to search for an empty column to start entering my data into and then move down the column to enter consecutive data values.
 
T

Tom Ogilvy

If the cell in row 1 will indicate an empty column

set rng = Cells(1,256).End(xltoLeft)(1,2)


--
Regards,
Tom Ogilvy

FutureWiz said:
Any one help me here? I am trying to create a macro/VB that will allow me
Click to expand...
to search for an empty column to start entering my data into and then move
down the column to enter consecutive data values.
 
F

FutureWiz

Thanks for the reply, but I'm not sure this is exactly what I am looking for. Could you explain in more detail what is going on?
 
C

chrispy180

that code finds the last column to select the last column insert
rng.Select

----- FutureWiz wrote: -----

Thanks for the reply, but I'm not sure this is exactly what I am looking for. Could you explain in more detail what is going on?
 
A

Alex Sossick

I have a similar problem
I want to go through cells for example a1 to a10 looking for the first blank
cell going down. Any ideas?

Thanks

Alex
 
Top