hmmmmm no maybe Im being a bit dappy!
In VBA how do you define a dynamic range?
I recorded a macro to define a named range using the OFFSET function...I got this....
ActiveWorkbook.Names.Add Name:="xRange", RefersToR1C1:= _
Is this how I declare it and then maybe use a loop to decide how many columns to find?
Oh dear Oh dear!!! Any Ideas??