bernard96
08-01-2016, 05:37 AM
Hello,
I would like to take a look at the code of an macro which is used to calculate the value in particular cell of the Excel 2007 .xlsm file.
How can this be done?
When I click on that particular cell, it shows the following function:
=IF(D8<>"Rooftop Only (See Ch. 4 of Guidelines)",'D) Subsurface Depth Sizing'!E19,"NA")
Does that mean that the macro which is calculating the value of that particular cell is: 'D) Subsurface Depth Sizing'?
The problem is that when I open the Microsoft Visual Basic and take a look at the objects inside of the VBA project, the 'D) Subsurface Depth Sizing' contains only this code:
Option Explicit
Private Sub Worksheet_Activate()
Range("A1:U1").Select
ActiveWindow.Zoom = True
If ActiveWindow.Zoom > 100 Then ActiveWindow.Zoom = 100
Range("A1:A1").Select
End Sub
And to make it more strange, all other objects contain the same code.
Why is that so?
Does this mean that the 'D) Subsurface Depth Sizing'? is actually not the Macro which calculates the value for particular cell?
Here is the .xlsm file: app.box.com/s/5soz2008frzqkg6zmoca5rz8katpz3h4
I am interested in cell F110 on "Inputs and Results" worksheet.
I apologize for my lack of VBA Excel knowledge.
Regards,
Bernard
I would like to take a look at the code of an macro which is used to calculate the value in particular cell of the Excel 2007 .xlsm file.
How can this be done?
When I click on that particular cell, it shows the following function:
=IF(D8<>"Rooftop Only (See Ch. 4 of Guidelines)",'D) Subsurface Depth Sizing'!E19,"NA")
Does that mean that the macro which is calculating the value of that particular cell is: 'D) Subsurface Depth Sizing'?
The problem is that when I open the Microsoft Visual Basic and take a look at the objects inside of the VBA project, the 'D) Subsurface Depth Sizing' contains only this code:
Option Explicit
Private Sub Worksheet_Activate()
Range("A1:U1").Select
ActiveWindow.Zoom = True
If ActiveWindow.Zoom > 100 Then ActiveWindow.Zoom = 100
Range("A1:A1").Select
End Sub
And to make it more strange, all other objects contain the same code.
Why is that so?
Does this mean that the 'D) Subsurface Depth Sizing'? is actually not the Macro which calculates the value for particular cell?
Here is the .xlsm file: app.box.com/s/5soz2008frzqkg6zmoca5rz8katpz3h4
I am interested in cell F110 on "Inputs and Results" worksheet.
I apologize for my lack of VBA Excel knowledge.
Regards,
Bernard