Hi all,

i have a format that i use to copy paste multiple times in my assignment using macros.

i see that copy pasting the shapes always take the reference to the cells declared in the first object. is there a way i use the position of the shape and select the cells accordingly?

for example, copy pasting the cells from a1:e46 creates the shapes again with the same names. and refer to the cells from a1:e33 if i save. infact, after i copy paste, i need it to select the cells from g1:g33

​Hi all,i have a format that i use to copy paste multiple times in my assignment using macros.i see that copy pasting the shapes always take the reference to the cells declared in the first object. is there a way i use the position of the shape and select the cells accordingly?for example, copy pasting the cells from a1:e46 creates the shapes again with the same names. and refer to the cells from a1:e33 if i save. infact, after i copy paste, i need it to select the cells from g1:g33    Read More

​