View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default moving sheet changes object assignment?

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.