Check if headers exists in Excel

[Jackcell]

Hi all,

I would like to check if there is any headers in the current excel sheet via macro.

 

[mole999]

if you know what you expect to find in Cell i.e. A1 should equal index then

IF sheets("sheet name").Range("A1") <> "INDEX" Then Exit Sub

 

[Jackcell]

Hi mole999,

The sheets are downloaded as a report, the headers will change constantly. Is it still possible to find? The manual way to do it is via the "sort" > check if the checkbox "My Data Has Headers" is checked.

Cheers

 

[mole999]

not sure how to test for anything that "might be a header but not sure" ?