I Have A formula in range F1,H1
What is the best way to stop the error "Selection too big" when running macro MyEnd Could Be H10000
Range("B65536").End(xlUp).Offset(1, -1).Select
ActiveCell.Offset(-1, 7).Range("A1").Select
MyEnd = ActiveCell.Address
Selection.AutoFill Destination:=Range("F1", Myend), Type:=xlFillDefault
What is the best way to stop the error "Selection too big" when running macro MyEnd Could Be H10000
Range("B65536").End(xlUp).Offset(1, -1).Select
ActiveCell.Offset(-1, 7).Range("A1").Select
MyEnd = ActiveCell.Address
Selection.AutoFill Destination:=Range("F1", Myend), Type:=xlFillDefault
