I"m getting the following error on my VBA:
Run time error '9': Subscript out of Range.
I'm sure it has something to do with the fact that for the data that I"m dealing with there is not a WS2 which holds "Y" because this data doesn't have Y values. I Need to figure out how to have the process ignore if there is no WS2 or WS1 to not error out.
Please Login or Register to view this content.
Last edited by alansidman; 09-30-2016 at 11:42 AM. Reason: code tags added
Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html
( I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Where in the code do you get the error?
If posting code please use code tags, see here.
Right afterPlease Login or Register to view this content.
It means the sheet does not exist. You need to check the spelling name of the sheet y.
This line
Dim WS1, WS2 As Worksheet
also means, only WS2 is declared as worksheet, but WS1 is declared as variant.
should be
Dim WS1 As Worksheet, WS2 As Worksheet
I changed it to
but I"m still getting the error. I know that Y sheet doesn't exist for this set of data. That's why I have the if not WS1 is nothing... same for WS2 is nothing... but I"m still getting the error.Please Login or Register to view this content.
If there is no worksheet named 'Y' you can't use Worksheets("Y").
I have a procedure before that will split the data into sheets based on the value in column H. Guess what I"ll have to do is have it do a certain set of code if there are both Ns and Ys in column H, if there is only N's and if there are only Ys. I thought adding an If statement to see if there isn't a worksheet for Y or N that it just ignored that. The values in the file will always be Y or N. there may be files that have both Y lines and N lines.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks