Range Parameters as Variables

Hi,

I am using a macro to create a graph, I would like to make the two range paramaters variables and get them from the user using inputboxes.

I know how to get the values using input boxes and assign them to variable names, but i do not know how to then make these variables the Range parameters.

Please Login or Register  to view this content.

"A7" and "K10" would become variables.

what i would like is Range(var1, var2).Select

jonnyuk3

Hello Jonny

if you want the users to specify an entire range to use, you don't need two parameters - you can get away with just the one:

Please Login or Register  to view this content.

Richard