Gurus,
I am attempting to read a list of employee names, create at worksheet, and rename the worksheet with the employees names. I get through the first loop but it stops at
On the second one. Below is the entire code. The error is run-time error '1004' Application-defined or object-defined error
Please Login or Register to view this content.
Any Clues?Please Login or Register to view this content.
TIA,
Tim
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
xladept,
That didn't work... However, I did find out that when it looped to cells(5,2) the value was blank. Which is why I get an error during the renaming of the worksheet. But there is a name in cell b5..
Stumped
Tim
You have not sheet reference for Cells(5,2) so it will refer to B5 on the active sheet and since you are creating new sheets that's probably going to be one of the new, blank sheets.
Which sheet has the list of employee names?
If posting code please use code tags, see here.
Ohhhhh that makes sense.
Employee list is on sheet("QP")
Try this.
Please Login or Register to view this content.
Norie,
Thanks for your code. I simply added the QP sheets in front of the cell value. It works just like I wanted. Here is what I ended up with.
TimPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks