Hi all
Could someone help me find the best way to return the column letter from a search?
For example, current code manually defines a range...
first_row = "AE2:CF2"
but I would like to make it more dynamic by including a search in there for the column headers in AE and CF which have unique strings so that if I add or delete columns, the range will still be between those two search strings
Thanks!
Could someone help me find the best way to return the column letter from a search?
For example, current code manually defines a range...
first_row = "AE2:CF2"
but I would like to make it more dynamic by including a search in there for the column headers in AE and CF which have unique strings so that if I add or delete columns, the range will still be between those two search strings
Thanks!