I have a sheet where I want to copy the contents of a column titled "Tourref" to another sheet.
Tourref can appear in U, or maybe W, or T, etc.
What I've got is a loop that goes horizontally until it finds the Tourref column, but in the VBA It was like this:
Range("U2:U" & Lastrowml).Copy...