Limits on Variants, strings, etc?

Hello,

I'm writing a code where you select the named dynamic ranges from one sheet and then the chart is displayed on another sheet. The only thing is, I have 32 different ranges they can choose from.

Does VBE have a limit on how many variables you can have? I'm dimensioning all of my ranges as strings (because of the chart), and then I have a couple worksheets and there may be more that pop up as needed. I would hate to code all 32 and then have VB tell me it can't think that hard!

Thank you!

katie

There are 32 ranges of data (coulmns N thru AT...and one in the middle that doesn't need to be counted) that I need to be able to graph (bar graphs). The goal is to have a button on the toolbar that will trigger a userform. The user selects checkboxes on the userform for which columns he/she would like to view on a graph.

I'll attach the dummy file of my workbook. The data to be graphed is on sheet one, 'Bid List'. The corresponding products need to be graphed vs the "Bid Date" column. If possible, I would also like to be able to graph only certain months......

thanks for taking a look

In VB, you can find the userforms frmMarket and frmSales. This is the kind of form I would like available. The workbook is not for my primary use, it's for my excel-illiterate coworkers, so the options need to be as straightforward as possible.

The halfway code for the userfrom frmMarket is started......I think i'll be dim'g all of those variables in a different way, with some thing like

Please Login or Register  to view this content.

and then coding something like

Please Login or Register  to view this content.

and code the rest of the sub for setting the chart ranges etc. I'm not sure if this is the best way to code it, but I think that the check box options might be the best option for user-friendly ness

Suggestions welcome!