searching for a null cell in a column
 

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.

searching for a null cell in a column
 

If the cell in row 1 will indicate an empty column

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


--
Regards,
Tom Ogilvy

"FutureWiz" wrote in message
...
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.

searching for a null cell in a column
 

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?

searching for a null cell in a column
 

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?

searching for a null cell in a column
 

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

in article , chrispy180 at
wrote on 7/1/04 3:06 pm:

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?