Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel Experts,
At the end of a number of modules in my code, I find specific text, and in the cell to the right, enter the text "DONE". An example would be: Cells.Find(What:="Save GS Files").Offset(, 1).Select Selection.Value = "DONE" Generally, I hide the column that contains the text that the cells.find looks for. Generally this doesn't cause a problem, but sometimes this part of the code fails, and to get it to work I have to unhide the column that hold the text. Is this a known problem where a cells.find command can't find text in a hidden cell or is this an unusually/bug type situation? Or should I be adding some additional parameters to the cells.find command? Thanks, Alan -- achidsey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find the first & subsequent cells to contain text in a column & re | Excel Discussion (Misc queries) | |||
How to find duplicate cells in Column a & retrieve column B | Excel Discussion (Misc queries) | |||
Find a text from a column in a text string within another column? | New Users to Excel | |||
Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
Find text in Column to sum | Excel Programming |