Is there a way in VBA to send an object (Groups made of Text boxes and Check boxes) to a set cell rather than using what record macro does of having the selected object move up or down with a numerical value.
The controls move whenever I copy a sheet that has a lot of hidden rows, they move to the highest unhidden row, so all I need to do is move them down. Is there a code of either moving the various groups to a specified cell or maybe counting the row height of a set range so I have the value to move it down by?
I'm having a major problem with this and I'm hoping I don't need to Ungroup it all and have the VBA run through things individually.
Any help is greatly appreciated, Thanks.
~Will S
The controls move whenever I copy a sheet that has a lot of hidden rows, they move to the highest unhidden row, so all I need to do is move them down. Is there a code of either moving the various groups to a specified cell or maybe counting the row height of a set range so I have the value to move it down by?
I'm having a major problem with this and I'm hoping I don't need to Ungroup it all and have the VBA run through things individually.
Any help is greatly appreciated, Thanks.
~Will S