Hi Kyle,
Thank you - I will look into that at some point when I have the time to invest! Looks a little hair raising, especially if a virus checker can delete the modules dependent on how it sees the vba writing behaviour!
As I said, the main goal was to find out if it is possible to automatically assign variables without naming them directly e.g. instead of having to type
they can be set indirectly using a reference from an array. e.g.
where
and I can then refer to the sheet using bw rather than array(I,2).
The bigger picture was expanding my understanding of VBA's capabilities - not just about saving a few keystrokes. There are some amazing solutions that are on this forum - a one/two line piece of code that saves dozens of lines - so I wondered if this would be a similar thing!
I was/am looking for a solution that does not require tinkering, but for now I shall use the longer method for my current project and look into the method above at some point in the near future!
Thanks again for your expansion. Sorry if it's not particularly clear what I'm after!
Bookmarks