Hi,
I’m looking for two things very urgently.
1st query: i have lost my vba password and have stored most of my codes in the module and hence had password protected it. Is there a way where i can either crack my password or even just can check my codes without hampering the password.
2nd query: i’m trying to use a loop which will take conditions from two different sheets.
one condition will loop until the last line of the row is executed and once the line gets executed needs to delete that line.
I have a list of start time & end time for each employee and have sorted this data in an ascending order.
Now what i need is to know, who can replace whom with regards to the timings.
For eg: A comes at 6:00 to 15:00
B comes at 12:00 to 9:00
C comes at 16:00 to 1:00
So, the system should check that C can replace A hence i would require 2 seats and not 1 for the above data.
Thanks in advance.
Regards
Roshan