help with the debug

[mada.]

Hi All,

I keep getting an error with the attached code.
any ideas?

30408

[Aussiebear]

Copy and paste your code rather than images please?

[SamT]

Select A1, then do your paste special transpose there. Be aware it will paste into 180 columns by 7 rows