Vba method. Run time error 9 subscript out of range vba. runtime error 1004. error macro.