Find Not working

[davidmhcampbell]

Hi there all,

I have some code I have pieced together that I can't get past "If SearchWB.Worksheets(1).Cells(1, j) = "*Open*" Then"

I have tried all sorts of different combos but to no avail.

Essentially, i have a workbook of data that I want to search for the appropriate column to bring into my master workbook. Help getting this line of code working, and a look at the rest of the code, would be greatly appreciated!!

Thanks in advance,

David

Please Login or Register  to view this content.

[GeneralDisarray]

Please wrap your code in tags.

Edit your post, Highlight all of the code (and only the code) and press the "#" button.

That will make the code easier to read and copy out.

[davidmhcampbell]

Updated... Thanks

[Arkadi]

your problem line is using wildcards... cant do that as far as I know... Are you looking for the word open in the cell? Iff so then try:

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[GeneralDisarray]

Instead of looping for the column with the word "Open" in the header, have you tried a .find()?

Something like:

Please Login or Register  to view this content.

That will pinpoint the header you are looking for right away. Does that help? Once you have that header, would copy the contents by equating the values with something like:

Please Login or Register  to view this content.

[davidmhcampbell]

Thanks everyone for the replies...

In the end I have found this to work...:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Looks a lot like yours GENERALDISARRAY, just with using a function.

I am about to start a new thread as I have hit another road block related to 'OVERFLOW'. I can't figure this one out as it goes deep into the process (loops at least 30 times) before this error rears its ugly head.... Stay tuned...

Thanks Again,

David

[davidmhcampbell]

Posted twice for some reason??

[AB33]

Please Login or Register  to view this content.

All integers should be change to long

[davidmhcampbell]

That fixed my overflow error AB33...thanks!!