Hi all
First of all; appoligies for the title. The new feature wouldn't let me enter XlUp. I dont know if after you search it will let you enter Xl. I had already search the threads and can't explain with out using XlUp.
Any who..
Ive been speeding up my code with
Code
Sheets("Input Data").Range("D6:AO505", Worksheets("Input Data").Range("D510").End(xlUp)).Copy Sheets("Matrix").Range("B52")
But Sometimes there will be no data in the range and this code will copy the row above the array D5:AO5 and paste in the Matrix2 range B52 which is the catalist for a cascade of errors
The only thing I can think of is to use named ranges - But a this stage when the calculations fallover - well a little anoying
Any pointers?
Regards
pike:sheep: