searching for a null cell in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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?
 
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?
 
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
 
Back
Top