Macro Help

[zac]

Hi,

I have some excel files.
I am consolidating them using a Macro.
In this process I wanted to store the Row ID of the cell in the excel
files with a text "Total" to a variable in the macro.
How can I do this.

Thanks in advance
Shaiju

 

[Bob Phillips]

Something like this

cell = Columns("A").Find("Total")
If Not cell Is Nothing Then

RowId = cell.Row

'etc.
End If