get values from cell that share the same content

[orr]

Hi, I just started programming in VBA.


I need to iterate through column "C" and compare the value of the cell with some string, if it is equal I need to print

the problem is that from C8 to C35 is only in one cell (c8), how do I get all others to get this values?

I don't know if I explained myself right, here is the excel file with the macro: Book2.xlsm

my code:

Please Login or Register  to view this content.

thanks guys

[patel45]

It's not clear for me, do you want put "CTC" in range C8:C35 ?

[orr]

thanks for replying

I want just to get the content of cells from C8 to C35 and I will then do some "operation" with them

but the problem is that only C5 return value (CTC) the others return empty, and they should (in my opinion) return also the value "CTC"

got it?

[orr]

because I will need to make a program that read an input that will be comparared to all the colun C.

If the input is "CTC" for example i need to compare all the C* (C1, C2, C3...) and see if it the value is equal do "CTC" if it is I will get the whole row and put in another sheet, the problem is that C9 should be equal to "CTC" but it is not, it returns empty

[patel45]

how can you put a value in range C8:C35 ? you can not, there is merged cells.
Divide cells in this range, you solve the problem

[orr]

thanks for your help

I found this function that will help me get the values

Please Login or Register  to view this content.

[HaHoBe]

Hi, orr,

or something like this:

Please Login or Register  to view this content.

Ciao,
Holger

[FDibbins]

orr, as you a new member,i have added code tags for you, but please remember to use code tags in future

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here