| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for first empty cell.
In Vb, I am trying to set as the ActiveCell, the first empty multiple of ~ 30
in column A. I.E. If A1 = "one" A31 = "Example" the program will spot this and set as ActiveCell A61. PS Although setting this as active cell may not be the best way to do what I am trying to do, I quite enjoy finding out for myself how to do things and so I am not too worried how messy my code is. This has got me stumped though, I can't even think of a long winded way to do it. Not when I could potentially use all 65k rows. I'd very much appreciate all assistance. -- Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT + ISNUMBER(SEARCH) + Empty Cells | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Finding next empty empty cell in a range of columns | Excel Programming | |||
| Empty cell and a the empty String | Excel Programming | |||
Threaded Mode
