Thread: [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
View Single Post
 
Old 11-03-2018, 05:45 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
That's quite unexpected. Could you attach the exact file itself here? If it has sensitive data in, you might be able to upload it to a file sharing site and private-message me here a password.
I'm thinking first along the lines of the code not being in a standard module, but in a sheet's or the workbook's module. The line Set RngToCheck = Range("D13:AB63") has an unqualified reference and it may not be the same as the ActiveSheet of the subsequent line.
Reply With Quote