Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a bit of code that searches a range object for the first blank cell:
Dim jswCell As Range Range("B1:B280").Select Set jswCell = Selection.Find(Empty) Debug.Print jswCell.Row & "," & jswCell.Column Once this is found, I would like it to start seraching from this blank cell, continue down the column, and find the first "not blank" cell, regardless of the value stored in that cell. I have tried different ways of telling the .Find method to find the next cell with a value, but everything I try gives errors. For instance, Set jswCell = Selection.Find(Not Empty) ....will not find a "Not Empty" value. How should I code this? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching for a "LESS THAN"" amount within a sheet! | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |