find column Ref.

[sksanjeev786]

Hi Team,
I have multiple files and tabs in excel data. and each tab has multiple columns so I need to find column Ref. where ever i have "Control" and "Delta" column only.


For attahced file it like B,C E,F

and all file has the same formate like row number 7 we can get control and Delta.

For ref. please see attached file.

Thanks in advance
Sanjeev.

 

[EFANYoutube]

Please try this

Sub ItsAllGood()
For Each Sheet In ThisWorkbook.Sheets
    ControlColumn = Sheet.Range("8:8").Find("Control").Column
    DeltaColumn = Sheet.Range("8:8").Find("Delta").Column
    Debug.Print "Control Column = " & ControlColumn
    Debug.Print "Delta Column = " & DeltaColumn
Next Sheet
End Sub

 

[sksanjeev786]

Please try this

Sub ItsAllGood()
For Each Sheet In ThisWorkbook.Sheets
    ControlColumn = Sheet.Range("8:8").Find("Control").Column
    DeltaColumn = Sheet.Range("8:8").Find("Delta").Column
    Debug.Print "Control Column = " & ControlColumn
    Debug.Print "Delta Column = " & DeltaColumn
Next Sheet
End Sub

Hi am not getting any data in the excel file. and I have check-in immediate "
getting the same column ref... instead of diff. column

Control Column = 3
Delta Column = 4
Control Column = 3Control Column = 3
Delta Column = 4
Control Column = 3
Delta Column = 4
Control Column = 3
Delta Column = 4

Delta Column = 4
"

Thanks in advance
Sanjeev