Variable Remains Empty after Macro Runs

Hi, I am having a specific issue as part of a much larger project. Quick background--this is for survey research data analysis. So, my data is constantly changing shape and size.

I am trying to create a variable "Denominator" based off a specific location of a cell. I need to then use this variable "Denominator" a few times to determine the proportion or percentages of times a specific answer was provided for each questions.

While I have two major issues right now, the first one to fix is the variable declaration problem.

The code is below, and the variable declaration is bolded. Even after I run the code and hover over the variable name the pop-up box informs me that the variable is Empty. I believe, this explains why I keep receiving #NAME errors when I got to divide my total value by the Denominator variable.

So, my question is what am I doing wrong?

Please Login or Register  to view this content.

I am open to suggestions for changing the formulation as a whole, I am still fairly new to VBA. So, if anyone thinks of an entirely different and better way to address the issue it is welcomed.

Let me know if there is any additional information that I can provide. I am using excel 2010

Thanks!!

First you have declared your variable but you have not made it public so it is only available to its host macro.

For other macros to be able to use it you need it to be public and at the top of a normal Macro Module.

Ok assuming you declare your variables as Public, they will be erased each time you close your worksheet.

So if you want to keep them then save them on a worksheet, either in a cell or as a name.

click on Formula and then name manager to create your name.

Save your workbook when you create your name and it will be saved too.

Please Login or Register  to view this content.

Once you have done that you can use denominator in your formulae.

type this into a cell:

Please Login or Register  to view this content.