referring to cells depending on their content

[Davide77]

hallo,
back with a new excel vba question:
how to refer to a cell depending on its content


something like:

a = .cell(x,Y) WHERE cell.value = "BLABLA"

thanks for suggestions

 

[BrainB]

What do you really want to do ?
eg. The way to refer to a cell value is something like :-
If ActiveSheet.Cells(1,1).Value ="BLABLA" Then ....

Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[Davide77]

I'm exporting a recordset from access to excel and I want to tell something like.
paste the value of the recordset in the cell on the right to the one there is "blbla".

The code is this:

g = 4 'the column number in the excel sheet
Do Until rs3.EOF ' do till the end of the recordset
Cellcont = rs3(i3 + 3) 'this is the content of the cell (taken from the recordset)

**which cell contain Cellcont**

Sht.Cells(x, g).Value = rs3(i3 + 4) 'paste the recordset value to excel cell
rs3.MoveNext 'next row
Loop

The part I need is between **