Skip to Content
0
Jun 11, 2018 at 07:01 PM

Performing Crosstab "Move To" programmatically using VBA

87 Views Last edit Jun 11, 2018 at 07:03 PM 2 rev

Hello,

I would like to move a crosstab to another location in my worksheet using VBA. Currently I'm doing this by cutting the range and pasting it elsewhere however that causes the uwanted behaviour of putting data in the planning buffer as if someone has planned. I tried to manually use the "Move To" option from the attached screenshot and it did the trick. Now the question is can I perform this using VBA?

Thanks,

Dimitar

Attachments

pic.png (19.7 kB)