Someone Please help me to fix this error. everytime i run my code its come up with this error (Run-time error '1004': Application-define or object define error), and its always highlight line #9 (Sheets.Add.Name = rcell.Value) on my code. My working files in on excel 2007 and its contain 87150 rows and 17 columns (A-Q)... Please view my code below.
Please Login or Register to view this content.
Thank You
Does rcell contain a value that's valid for a sheet name?
If posting code please use code tags, see here.
Thank you Norie for reply....Yes all rcell value is valid.... they're all number with 6 digits.
No duplicates, no blanks, no errors?
As Norie suggests, my first thought is a duplicate, which would cause that error. You are checking that the current cell is different than the cell in the immediately previous row, but it could be the same as some other cell in an earlier row.
it has some duplication data on the first column (ID) ... no other errors and no blanks
Any duplicate would cause the error, and like Jeff says you are only checking if the cell above rcell is a duplicate, you aren't checking any other cells.
so how am i gonna check any other cells with my code,, please
My code is working fine with this sample files (maka2)..but when my file grow up to 87150 rows the error comes up.
The real way to solve this first must consider what you want to do when you encounter a number and there is already a sheet named using that number. What do you want to happen in that case?
A simple but unsophisticated way to solve this is by sorting your data on column A. Then your code will work.
Another way is to ignore errors, adding the lines shown to your existing code. If an error occurs creating a new sheet (most likely because of a duplicate), the code skips trying to copy the row of values, and simply keeps going. I have tested this.
Please Login or Register to view this content.
Still not working
Attach a file that exhibits the error. If it's large, store it to a zip file before attaching.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks