Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: fabrigatti
- Order by date
-
Automatic calculation when opening XL file
Yes, you are right! I used the IF function. If the condition is true, then apply a formula to that cell. If the condition is false, apply another formula. This worksin the first box only. If I copy the cell contents with the right button, the formulas are substituted with values and the...- fabrigatti
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Automatic calculation when opening XL file
This command works fine: ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-4]" However, how can I complete the formula considering that I have to check if the difference between 2 values is bigger or lower than 30 (minutes) and, basing on this, add 30 minutes or less? My rows are like this: A...- fabrigatti
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Automatic calculation when opening XL file
Hello, I need to automatically calculate the values on a column of an Excel files, as soon as I open it and basing on values manually inserted in boxes of the same worksheet. Where can I start from? Regards Fabrizio.- fabrigatti
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
