Get instant live expert help on I need help with excel macro if statement
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a clock running in excel 2013, when it reaches several preset times I want to run a macro to count down to an alarm, the clock works, the macro works if I run it from the macro screen but I am having difficulty to call it from a cell. Can I use an IF statement.
Solved by D. A. in 23 mins
I have a clock running in excel in Excel on sheet 1. When it matches a time stored in B4 I want to trigger a macro "Macro2" running in sheet 3, I have true/ false statement in D4 I Tied an If statement basically saying =IF(D4=True) the run Macro2 but it did not work, niether did your suggestion of :- Private Sub Worksheet_Calculate() If Range("F1") > 1 Then Application.EnableEvents = True Run Macro"'Trial timer3.xlsm'!Macro2 Range("D4:D6") = "" Application.EnableEvents = False End If End Sub Can you help
Solved by Z. J. in 19 mins
I don't see why you think this is not a spreadsheet problem!! I have a clock running in excel 2013 spreadsheet, when it reaches several preset times I want to run a seperate macro to count down to an alarm, the clock works, the macro works if I run it from the macro screen but I am having difficulty to call it from a cell. Can I use an IF statement.
Solved by S. H. in 22 mins
I need an excel macro to auto-generate multiple pivot tables and data tables from a very complex financial statement. Serious experts only otherwise i will rate you 1 star
Solved by M. A. in 26 mins
Need help with IF SUM statement in excel.
Solved by T. S. in 14 mins