I created a Macro recently which checks the row count of an object and if it is < 500 will export the data to Excel. Otherwise, it will present a message that the row count is too high.
I'd like to change this to use variables instead of having the max row count hard coded and I'm having difficultly getting this to work. I currently have a variable called "vMaxRowCount" with a value of 500. In my aforementioned Macro I have the following line: