-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
calculate event
-
M
Hide row error on worksheet calculate event
Hello, I have a hide row on a calculate event which is partially working when it is above and below a given value. 1. H57 is a calculation with an error message =IFERROR(SUM(G41:G51,G54:G55)/SUM(E41:E51,E54:E55),"please complete all sections") 2. my code Private Sub Worksheet_Calculate() If...- mandalocascio
- Thread
- calculate event hide / unhide rows
- Replies: 3
- Forum: Excel Questions
-
R
VBA Time stamp based on formula value change
Hello, I have looked everywhere I feel like for a solution to my problem. I have never worked with VBA before, and am having trouble finding a solution for my problem. I have a range of cells, "D:F", in which I need a time stamp to be placed in column "I" on the event of any of the formula...- rvalizan
- Thread
- calculate event date stamp vba
- Replies: 0
- Forum: Excel Questions
-
O
formatting a pivot chart: formatting is lost on change of page data
I have a pivot chart with 5 series and three page fields on it. When the page fields are updated the chart is refreshed. There is a 'bug' in pivot charts that means that the series are refreshed and all formatting on the series is lost. Not a problem in itself because I can reformat using a...- obiron
- Thread
- calculate event formatting pivot chart
- Replies: 1
- Forum: Excel Questions
