Macro/Excel Find Function

What are you searching for?

Hey Stephen

I'm searching for the actual column titles for example in the attached workbook I would search for "DH Gauge Press" or "WHT @ SST". But I can't seem to find these cells when I'm using the find function. I believe it has something to do with how they are spaced. I've tried several combonations of typing these into the find functions but with no luck.

Also the reason I am trying to find these columns is sometimes the reports I recieve have new columns or rows inserted so I want something more reliable than just copying the value of an assigned cell. Say for example E30 in old reports has "Guage" information but in newer reports E30 has "Sub-Sea Choke" data.

Thanks for your interest

Yes it's those invisible carriage return characters I think. Here is one approach (get rid of them):

Please Login or Register  to view this content.

Thanks,

But just so I'm clear.

This code goes to row 5 and replaces invisible charecters right? if so it a great approach but in these reports I'm working with rows are subject to change as well.

For example a year ago the Column titles would have been in row 4, today they are in row 5. and tommorow who knows where they could be. I'm trying to create a way of finding data regardless of its reference location.

Thank you much though

Anymore thoughts?

This will do the whole sheet:

Please Login or Register  to view this content.

Ahhh ha! excellent I shall give this a try and get back to you! Thank you soo much!

Works Great... here's the final sample code I've constructed

Please Login or Register  to view this content.