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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
For-Next by a row Counting consecutive Zero in the column 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Search for empty cells and move cells next to 10
A data validation question 1
Excel Macro: insert formula into first blank cell in column & auto 2
OFFSET LOOKUP function in VBA? 9
How to delete ALL cells containing the same data 1

Back
Top