| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nulls within a .Find command
Here is the code:
With Workbooks("Workbookname.xls").Sheets("Total").Rows (1) ColToFind = .Find(What:="What I am looking for", After:=.Cells(.Columns.Count), _ SearchOrder:=xlByRows).Column End With The problem is sometimes ColToFind is not going to be there. I need a way to tell it that if ColToFind comes back null then do not continue the module. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I test for nulls within a range without specifying each ce | Excel Discussion (Misc queries) | |||
| replace zeros with nulls | Excel Discussion (Misc queries) | |||
| replace zeros with nulls | Excel Discussion (Misc queries) | |||
| deaking with nulls, I think... | Excel Programming | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Threaded Mode
