Hello:
Please refer to attached file.
I am using below code succesfully to get unique names from column B into Row 2 staring in cell E2 as shown.
What i want is to have cell j2:Z2 = 0 in this case.
Please Login or Register to view this content.
If i had names until P2, then Q2:Z2 = 0.
Please help modify the above code to add this feature.
Let me know if you have any questions.
Thanks.
Riz
Last edited by rizmomin; 12-27-2014 at 07:17 PM.
Try this....Change range to suit your needsPlease Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi gmr4evr1:
It works but small problem.
Please run the macro i have created in the uploaded file to see the result.
Basically my code is going create a unique name list and it will paste at position starting cell E2.
I could have a long list of names.
If the list ends at H2 then zero should start from I2 till Z2.
If the list ends at say S2 then zero should start from T2 till Z2.
I hope this is clear and once again let me know if any further question and as always help is greatly appreciated.
Riz
hi rizmomin,
Please Login or Register to view this content.
Last edited by watersev; 12-27-2014 at 07:48 PM.
Hi watersev:
Thanks a lot, this works as per my specs.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks