Hi everyone
i have this section of code that end in a Run Time error 91
the weird thing is i can sometimes get it to run with no error... :S
it used to work fine and now its giving me the error, where am i going wrong.
what im trying to do is filter the excel sheet, down to what is stored in a text box.
then because the sheet is filtered i need to know what the last row is that has data in it.
then i want to save data from J2 all the way down to the last row in column J.
there is more code after this but its the filtering and finding what the last row number is thats not working.
sometimes the code works and sometimes i get a run time error 91.
i dont understand why sometimes it will work.
Bookmarks