Hello All,
I am having an issue with a line of code in a macro that otherwise works perfectly week in week out.
Please could somebody advise me as to what needs fixing in this line of code? I cant quite figure out what is different about this data set that is causing this error when it usually ruins without error.
Please Login or Register to view this content.
Thank you in advance
Did you?
Dim rngX as Range
Hi John,
Thanks for the response.
Yes this is the full section of the macro.
Please Login or Register to view this content.
Try:
AFAIK rows before columns when using cells as range.Please Login or Register to view this content.
Which line do you actually get the error on?
If posting code please use code tags, see here.
Hmm, Thanks for the feedback John but that appeared to give the same error.
Norie i get an error on this line:
Please Login or Register to view this content.
Apologies... the error now reads
"Run-time error '9':
Subscript out of range"
That means you don't have a worksheet with the name specified in column A on one of your processed rows. When the error occurs double-check the contents of that cell.
Everyone who confuses correlation and causation ends up dead.
What happens if you change the code to this?
Please Login or Register to view this content.
Last edited by Norie; 11-18-2014 at 10:05 AM.
Norie that seems to work perfectly.
Thank you. Much appreciated
Please advise what that must mean in regards to why the the initial issue came about?
When you say it's working perfectly, does the message box never appear?
What I thought was wrong with the original code was that find was failing to find what you were looking for on the sheet you were looking on.
When Find fails it returns Nothing, and you can't offset from Nothing.
The code I posted checks if Find was succesful and only then does the offset and executes the rest of the code.
If Find wasn't succesful the message box would be displayed.
The message box did appear for one line of data in the one of the data sheets. After skipping that the rest of the macro ran without error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks