Ehtisham Ali
Member
Hi fellas,
I am working on a vba project and within it I want to insert a standard formula into a range. I have written but somewhere it is not working please help.
You can refer to my code above. It is stopping at the 2nd line (Range("t2")........)
I am working on a vba project and within it I want to insert a standard formula into a range. I have written but somewhere it is not working please help.
Code:
'call resolution time line update
Windows("ABG_2Hrs_Report_Automation_Tool_ver2.0.xlsm").Activate
Range("t2") = "=if(s2*24<2,""<2 Hrs"",if(AND(s2*24>2,s2*24<4),""2-4 Hrs"",if(AND(s2*24>4,s2*24<8),""4-8 Hrs"",if(AND(s2*24>8,s2*24<24),""8-24 Hrs"","">24 Hrs"")))))"
Range("S1").Select
Selection.End(xlDown).Select
Range("K" & n).Select
Range(Selection, Selection.End(xlUp)).Select
Selection.FillDown
Selection.End(xlUp).Select
You can refer to my code above. It is stopping at the 2nd line (Range("t2")........)