Hello all,
I am getting an error with my code: 1004 Method 'Range' of object '_Worksheet' failed at the lines indicated below. The code still doesn't work when I set j = 11 & k = 40, but the code DOES work if I set the range to A11:A40. Any ideas as how to remedy this? I need to be able to change a lot of variables with the macro, including the range being searched, which is why I have a mess of ranges specified as cells.
Points for helping!
Please Login or Register to view this content.
Bookmarks