Forum Discussion
VBA Debugging Help
- Mar 23, 2023
Call print_sheet_risk_assessment(Sheet_3) fails because the procedure is named print_sheet_RISK_ANALYSIS, not print_sheet_risk_assessment
Call prints_sheet_hazard_control(Sheet3) fails because the procedure is named print_sheet_hazard_control, not prints_sheet_hazard_control
In print_sheet_RISK_ANALYSIS, you declare a variable area_print but then use print_area
In print_sheet_hazard_control, the line
greatest_large = WorksheetFunction.Max(a, B)
fails because a and B have not been assigned a value.
The variable greater_large has not been assigned a value. Should it be greatest_large? Or greatest_big?
Same confusion between print_area and area_print
Same in print_sheet_memory_help
find_last_row_written, management_particular_case and management_case_ASP_Construction are not in the code as posted.
In copy_PPE_in_temp, should instructions be statements or vice versa?
management_val_mult_training etc. do not exist.
In management_val_mult_instructions,
long_car = Len(statements)
fails because statements has not been assigned a value, nor instructions (are they the same?)
Should long_car and long_char be the same?
And lots more, but by the time I got there I had had enough.
Call print_sheet_risk_assessment(Sheet_3) fails because the procedure is named print_sheet_RISK_ANALYSIS, not print_sheet_risk_assessment
Call prints_sheet_hazard_control(Sheet3) fails because the procedure is named print_sheet_hazard_control, not prints_sheet_hazard_control
In print_sheet_RISK_ANALYSIS, you declare a variable area_print but then use print_area
In print_sheet_hazard_control, the line
greatest_large = WorksheetFunction.Max(a, B)
fails because a and B have not been assigned a value.
The variable greater_large has not been assigned a value. Should it be greatest_large? Or greatest_big?
Same confusion between print_area and area_print
Same in print_sheet_memory_help
find_last_row_written, management_particular_case and management_case_ASP_Construction are not in the code as posted.
In copy_PPE_in_temp, should instructions be statements or vice versa?
management_val_mult_training etc. do not exist.
In management_val_mult_instructions,
long_car = Len(statements)
fails because statements has not been assigned a value, nor instructions (are they the same?)
Should long_car and long_char be the same?
And lots more, but by the time I got there I had had enough.