Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.find not finding formula result
Set sc = ActiveWorkbook.Sheets("Region").Rows("4:4").Find(l store)
lstore value is "chicago". When a cell in row 4 has a value of "chicago", the line works fine. But when a cell in row 4 has a formula that results in "chicago", sc is Nothing. What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find formula result | Excel Discussion (Misc queries) | |||
finding 1 formula result in a group of cells | New Users to Excel | |||
Finding minum positive from the result of formula | Excel Discussion (Misc queries) | |||
How can I find cell contains the result of "maximum" formula | Excel Discussion (Misc queries) |