| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| how can I return the value of the first not null cell in a column | Excel Discussion (Misc queries) | |||
| How to do calculations with Null in the column? | Excel Discussion (Misc queries) | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
| How do I Excel countif column a =? and column b = null ? | Excel Worksheet Functions | |||
Linear Mode
