thread68-1732600 Hi I am using

[Brianfree]

thread68-1732600


Hi I am using this macro again for a new project but i keep getting the same problem with...

cl2.Resize(10 ^ coun - 1).Insert Shift:=xlDown, CopyOrigin:=cl.Copy()

I do not understand what is causing the problem. The macro works and populates the data?

Please can anyone advise??

Many thanks

Brian

 

[SkipVought]

Macro help >> forum707

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[combo]

There may be problem with CopyOrigin parameter, it's a bit mysterious. I did some research how to use it, most of some sites state that it can be any of XlInsertFormatOrigin enum values indicating what format apply to added cels.

combo