How can i check specific characters of a cell?

[ssbhardw]

Please Login or Register  to view this content.

My problem is that class variable doesnt return any values when i try outputting it on a cell. my goal is to compare its value to the ones specified in the IF statements to see if that part of text exists within the cell. If somebody could help me it would be appreciated. I have attached all my code, what i am doing is counting the amount of times val1 is repeated within the second spreadsheet. the counter ( objName) is supposed to be seperated based on the different class values.

[shg]

1. For starters, suggest you put Option Explicit as the top line of the module, and then define variables until your code compiles.

2. In this declaration, everything except count is declared as a variant.

Please Login or Register  to view this content.

It should be

Please Login or Register  to view this content.

3. Undeclared variable objname is not initialized before it's tested.

4. Nobody's likely to provide any useful help without seeing the workbook (sanitized as required) and reading a clear explanation of what you're trying to do.

[mrice]

I'm having trouble understanding what you are trying to achieve here as its difficult to see what the code is doing when there is no data to refer to. Would it be possible to post a copy of the actual workbook together with something which shows what the desired output would look like.

In response to your question about comparing strings, you may be helped by the INSTR function.

[Marcol]

In addition to the posts above

I'm surprised you get errors at all!

Since

Please Login or Register  to view this content.

can only ever return ""

I think you noticed that yourself

My problem is that class variable doesnt return any values when i try outputting it on a cell

How did you manage to raise errors in your If statements, especially considering your code does not compile because of a missing End If