Hi All,

I have some code that finds the last column that contains a date. If this column is AD or somthing like that the range will be B to AD and this is too much. How can I select just the last 10 columns?

Also if there are less than 10 columns I need it to be from B to what ever the last coloumn is. eg. B to G