Good day!I need to create several rows of, say, 20 rectangles. Which creation method will be faster using VBA?
1. Create each rectangle individually2. Create the first rectangle, and duplicate the rest with offset3. Create the first rectangle, and copy the rest with an offset4. Creating the start and end rectangle and creating blend between them
if you are creating duplicates of a single shape, then I would suggest that you look at the Shape.StepAndRepeat method.
There is also a ShapeRange.StepAndRepeat method that can duplicate multiple shapes.
Oh, thank you, i didn`t know such method exist. I think it is very comfortable to use it.
In terms of speed, is it also faster than the others?
I have never performed tests to compare the speed of all of those different methods.