Cells.Find and text in hiddend column
Hi - I had the same problem in a row, and I was NOT selecting the cell.
Values just don't work, and I can't use .formula in my app.
I tried the simple loop below, and it 'found' the value in a hidden row, go
figure?
for Row = 1 to 10
if cells(row,2).value = "what you're looking for" then exit for
next row
' if row is 10 here, then the value was not found.
--
Neal Z
"achidsey" wrote:
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
|