Hi, I am trying to write a macro that automatically activates the sheet that has the same name in Cell A14 to do some changes.
It should loop from A14 through A36 and do the same thing each time.
this is the code I have written, but it does not work.
I also uploaded a sample of my workbook.
Please Login or Register to view this content.
Instead of
Cells(" & total & ", 2)
try by using..
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Try this code
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@ Debraj Roy, it does not work
It doesn't work the way I want it, I only want it to make the changes to the employees who have a status P
Change this line fromtoPlease Login or Register to view this content.Please Login or Register to view this content.
Last edited by arlu1201; 09-02-2013 at 07:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks