Using VBA to determine where the "Header Row" is located in file

[welchs101]

I have a macro where i open up several files and then process each one as i open it up.

One thing that keeps changing is the location of the header row. As a result the macro stops / or results in erroneous results if i dont find the header row correctly.

So i was thinking of defining the header row as follows:

Header_row: Is the row with most entries and has the rt-most entry in a given row.

I was thinking of using this last statment to help ID the header row. But i am not sure the best way to even approach this without creating a prgm that takes for ever to run.

I am enclosing a file to help.

[welchs101]

i found this code online. It finds the col which has rt-most data in it and returns the row for that which has the rt-most data in it.

Please Login or Register  to view this content.

i think this should work..........

[welchs101]

ok this does NOT work.

Problem: Lets say that header row (row=1)and last data row in the table (row=32). SInce both have the same "last column". What i am finding is the row for the last data row not the header. Code is below..........i also include an excel file

Please Login or Register  to view this content.

[welchs101]

ok.......this is what i came up with.........seems to work..........famous last words by me

Please Login or Register  to view this content.

[welchs101]

did not paste all the right code

Please Login or Register  to view this content.

[welchs101]

ok, still not working 100%.

anyone have any ideas let me know.

If col has blanks in it obviously it does not work.

[welchs101]

posting a new file. use sheet 2............goal is to find the header row which is row 17..........

any ideas how to do this?

[welchs101]

any one have anythoughts on how to identify the "header row" of a file.

I define what that is in my first post of this thread.........i have also included files showing the header row.................

anythoughts would be appreaciated