Runtime error 1004

[ajaypal.sp]

Hi,


Pls go through the attached excel file. I could not understand why iam getting (At yellow colored line) "runtime error 1004: Application-defined or Object defined error.

Pls solve my issue.

Regards
Pal

[AB33]

You can not have ups(rows) and downs(columns) mixed up

Storedata = Range("a1", Range("a1").End(xlRight).End(xlDown))

If you going down

Storedata = Range("a1", Range("a" & Rows.Count).End(xlUp))

Going to the right

Storedata = Range("a1", Cells(1, Columns.Count).End(xlToLeft))