Hi
Does anyone know how to creat a dynamic variable name. I actually want to create a dynamic range variable though I've tried so many things now and its not looking good. Basically I don't know how many different variables I'll need each day so if I was to run a macro the idea is it would count the number of values or ranges in a worksheet and allocate a range variable to each one of those ranges. I had some ideas using a string and a count function but can't get it to work. Could anyone suggest anything here.
Thanks
Bookmarks