How to use Cells.Find function to search only in one column?

[dduranic]

I want to find a content of ActiveCell only in column "C", beginning from cell C4.What must be in Look in, and Look at?How to accomplish to match whole number,ex. "1" in cell with "1",no to find "1" in "123"!

This function searches in whole sheet,but i need only in C column!
Cells.Find(What:=ActiveCell, After:=[c4], LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate

Please,help me!

 

[Sir Phoenix]

Perhaps this?

Stealing a bit of code, please forgive me: :P

Sub findit() 
Dim c         As Range
Dim myCell As Range

Set myCell = ActiveCell 'replace with cell where the next column
                                   'has the base value to add to.
                                   'Code assumes search starts at next row.
Set c = Range(myCell.offset(1).address+:C65536").Find _ 
    (What:=ActiveCell, _ 
    LookIn:=xlValues, LookAt:=xlWhole, _ 
    SearchOrder:=xlByRows, SearchDirection:=xlNext, _ 
    MatchCase:=False, SearchFormat:=False) 
If Not c Is Nothing Then 
    myCell.Offset(, 1) = c.Offset(, 1) +myCell.Offset(0,1)
    'Add D value from searched C to D value from initial C.
End Sub

 

[Scott Huish]

That would search after the data, you are also missing an End If.

 

[dduranic]

Yeeees,that the function i needed.
HOTPEPPER,thank you very much!
That is the excel table that is connected with datebase which contains records with products.I use it when we counting the products in shop and checking that their quantity is the same as in the datebase.As we have same products on different places, I need this function to add their quantities.
You have drink when you come to Croatia.