Find function doesn't work with reference and non-visible text in cell (Excel2007)

Since you're using code anyways why not just expand the column(s) and then put them back to the width you want. You can turn off the screen updating so the user can't see what's going on.

Dear jrdnoland,

Since you're using code anyways why not just expand the column(s) and then put them back to the width you want. You can turn off the screen updating so the user can't see what's going on.

Maybe that will be the best and only solution there is, because I still haven't found a clue to get the job done otherwise.

Thanks for the reply and the idea!

Maybe someone else has the master solution??

Cheers, Wiggert

Hello Leith,

Thanks for the reply!

I'm getting a compile error: Unvalid qualification.

What would be the purpose of the "*" code?

Also:
Dim findCell As string
findCell = Range("B3").text

gives the same error.

And:
CDate("*" & findCell & "*") gives the error in dutch; typen komen niet overeen. The translation would be something as The types don't match.

Hope you know what the problem is? because I do not..

Thanks! Wiggert

Hello Leith,

Thanks for the thorough explanation.

It still isn't working. I used this code:

Please Login or Register  to view this content.

I'm getting the error that the objectvariable or blockvariable With isn't given.
This ussualy implies that the find function hasn't found anything, right?

It is a logic reaction I think, because findCell is now a value (e.g. 38765) and the cells in the sheet only contain date formatted values.

Also when I use findcell as a string:

Please Login or Register  to view this content.

The macro also returns the error objectvariable or ... etc. isn't found, allthough findCell has the 'value' "1-1-2009". So why doesn't it find a value in the sheet without cDate then?

Any suggestions?

Thanks again! Wiggert

Hi Leith,

Isn't that the .xlsm file I attached in my first post? Can you open that file with excel 2003?

That file hasn't changed since then.

I also attached a .xls file.

Thanks for the effort!

Wiggert

Exactly!

And I was hoping there would be a simple solution for this.

I'm hoping you'll come up with a great solution!

Merry Christmas everybody!

Wiggert