G
Guest
I have a data sheet, which I had assigned to a worksheet variable, shData
I used code
shData.move after:=shADI
where shADI is another worksheet variable.
I just found out that doing this moves the worksheet just as I want, but the
object, shData loses it's assignment. It's not a problem, because I can just
reassign it after the move, but does anyone know why it loses the assignment?
Something to do with the internal workings of the object itself?
Thanks.
I used code
shData.move after:=shADI
where shADI is another worksheet variable.
I just found out that doing this moves the worksheet just as I want, but the
object, shData loses it's assignment. It's not a problem, because I can just
reassign it after the move, but does anyone know why it loses the assignment?
Something to do with the internal workings of the object itself?
Thanks.