Macro Help

  • Thread starter Thread starter zac
  • Start date Start date
Z

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
 
Something like this

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

RowId = cell.Row

'etc.
End If
 
Back
Top