I am looking for a code that does this. I am tired to manually mentioning the first and the last column header address in all of my functions so need this macro to grab these extreme left – right cell address. Now..
What it does >> it looks at sheet1 - the very first row that has the column names – searches left and right….when it searches left, it grabs c1’ cell address (B3) - when it searches extreme right, it gets the c9’s cell address and finally give s a msgbox saying :
Left Header Cell : “B3”
Right Header Cell: “J3”
Please note that the first row that has the column names can be at row 3 or any other row…so it has to do some type of search or something