Search column by its name

A

airbatucampur92@gmail.com

New member
Joined
Jul 9, 2014
Messages
11
Reaction score
0
Points
0
How can i search column by it header name?

Code: 
processrow = Matchup(.Cells(i, "J").value, target.Columns(1))
            If processrow > 0 Then

what i mean is, currently this code will search column 'J' but i want it search by its name for example 'Process'.
instead of looking for 'J', it will find 'Process'

Thanks.
 
airbatucampur92@gmail.com said:
but i want it search by its name for example 'Process'. instead of looking for 'J', it will find 'Process'
Click to expand...
I've never heard of the function MatchUp so it's probably a function you have somewhere as code. At a guess it could be:

processrow = Matchup("Process", target.Columns(1))

or less likely:
processrow = Matchup(.Cells(i, "J").value, "Process")
We'd really need to see a bit more surrounding code and the MatchUp function too.
 
Sorry for not giving you full code
I have example like below

let say my C column is 'Address.
how to replace it

Code: 
yearidx = Year(.Cells(i, "C").value) - Application.Min(target.Rows(1))                
monthidx = Month(.Cells(i, "C").value)
                If Application.CountA(target.Rows(processrow)) > 1 Then
                    processrow = processrow + 1
                    target.Rows(processrow).Insert
                End If

thanks.
 
I understand even less now!
 
You must log in or register to reply here.
Back
Top