I have approximately 200 variables that I need to populate with values from one of my sheets at initialization. Currently, I have approximately 200 "if" statements to perform this task. example:
In Module 1 (only has my Public definitions):
Public CRptNameC as Integer
Public CRptNameR as...