Range object problem in VBA

**pani_hcu** · 08-26-2009, 01:20 PM

Hi All,

I am getting a run time error 1004 when i am running this macro. I got this macro to my earlier thread. As i am a beginner in a macro, I am unable to identify the problem.

I have attached the workbook for the same

Thanx in advance..

Regards,
Upananda

**royUK** · 08-26-2009, 02:51 PM

is this working correctly?

**pani_hcu** · 08-26-2009, 03:24 PM

Hi,

Thanks a lot but still not clear what was the problem ?

Regards,
Upananda

**stanleydgromjr** · 08-26-2009, 03:26 PM

pani_hcu,

I found the following that caused the problem, and have fixed it - please try it out.

Please Login or Register  to view this content.

See the attached workbook "Copy of stock return(1).xlsm".

And run the "TransposeData" macro.

**pani_hcu** · 08-26-2009, 04:53 PM

Hi All,

Still no clue what is happening inside, when i am pasting into another worksheet, the same macro is no more working. Same error code i am getting .

As this is very urgent for my research, any suggestion will be highly appreciated.

Regards,
Upananda