Hello everyone,
I'm using VBA in a rather unconventional way by moving some hexagons around on the worksheet. And I want the hexagons to be arranged in a certain way. I did the tedious task of recording all of the different macros necessary to move the hexagons into their specific positions. So I now have 15 independent subroutines that each specify where a different hexagon is meant to go.
The following code is the general idea of what I want to accomplish. Is this possible?
Note: let's pretend all moving macros are named Move1, Move2, Move3....Move15
dim counter as integer
dim hex_macro as string
for counter = 1 to counter = 15
hex_macro = "Move" & counter
Call hex_macro
next counter
Thank you for your input!!!
Bookmarks