the object invoked has disconnected from its clients

I posted this question:

"Say I have the following data all in the same column:

/****** Object: [Table1]
AD
RW
SD
TD
GG
/****** Object: [Table 2]
LK
IM
HJ
/****** Object:[Table 3]
PQ
WE

Before each row containing /****** I want to insert a new, empty row. How can I do this?

Things to note:
- in between the rows containing '/******' there is a different number of rows of data each time
- each row containing /****** is followed by data which is different each time e.g. Table 1, Table 2, Table 3"


The following code was suggested to me:

Please Login or Register  to view this content.

However, when I try and run this code, Excel stops responding and I get and error: "the object invoked has disconnected from its clients"

Any ideas how to resolve this? Could it have anything to do with running on Vista?

Thanks

Hi exccellar,

Try the following code. It may help you on your way

Please Login or Register  to view this content.

excellar

Please takee the time to actually read the Forum Rules that you agreed to & use code Tags when necessary.