applying

I've recorded a custom sort. The sort works exactly how I want, when manually applied (during record process), but fails to apply when applied by executing recorded vba code; by fail, I mean not applying sort and no error messages displayed. After the code has completed, I can visit the "Custom...

Hello Everyone , I am trying to create an excel application for leave, I have got the template online and its perfect for me. I want to create a validation while applying leave and need your help for this. While applying for leave the system checks the employee column (Employee are divided...

Hello guys, I need your help. My created a long formula in Excel and I need to convert it to VBA. I've been trying a couple of things, but always failed. Can you please help me? So the formula (for example for cell G50) looks like this...

I am applying 4 conditional formatting rules to 184 cells. I figured out how to correctly apply the formula and the colors I want but it is going to take forever doing it one at a time (that's 736 rules). Is there a way to do this more efficiently? The rules for the first cell (O7) are...

I have problems when applying the following code ActiveSheet.Range("$A$1:$B$7").AutoFilter Field:=1, Criteria1:= _ "<01.08.2018", Operator:=xlAnd When the macro activates the filter. All values are filtered and are not visible in the list (values larger, equal and lower than...

Tried for the D column: #=IF(E5 <= 0, LOOKUP(2,1/($D$4:$D$33<>0),$D$4:$D$33), E5)# I got this answer from this website but I'm unable to make it work properly. The sum in I4 doesn't calculate properly, either. More details of issue in image: Thanks for all your help!