Find the Header Row in a Sheet VBA

[austinandrei]

Hi,
This might be easy but I don't know how to look for the very first non-blank cell which pertains to the header on an entire sheet. My colleagues won't be giving me a file where the header is always in ROW 1. I know a code that can look on the very last non-blank cell in a column using a SINGLE VBA line and I want this to have an opposite function to look for the very first non-blank cell in a column.

This is the code I used for variable to look for the very last non-blank cell in column 1:

lastrow = Cells(Rows.Count,1).End(xlUp).Row

I need the same SINGLE LINE VBA CODE to have the opposite function to look for the very first non-blank cell in Column 1.
Thanks in advance!

 

[Norie]

Try this.

FirstRow = Cells(1, 1).End(xlDown).Row

 

[austinandrei]

Ah Thanks Norie! I knew it was easy and not sure why I haven't thought of that. Haha. Thanks!