Run time error 1004 when adding rows

**jpruffle** · 09-27-2009, 04:25 PM

Hi,

I have the following code, called from a Userform:

Please Login or Register  to view this content.

Sheet1 that I run it on goes to column IR leaving 4 blank columns. Sheet5 runs to IQ leaving 5 blank columns. I only have about 100 runs of data.

Any ideas would be greatly appreciated.

**stanleydgromjr** · 09-27-2009, 04:35 PM

jpruffle,

Try:

Please Login or Register  to view this content.

**Shijesh Kumar** · 09-27-2009, 04:37 PM

not able to find object ..

Can you post ur workbook

may be sheet5 is not there....

**pike** · 09-27-2009, 05:41 PM

Do you have a sheet5 or a sheet with the name "Sheet5" but could be sheet2?

The name on the sheet is not always the object number
other wise it works for me

**jpruffle** · 09-28-2009, 07:35 AM

Thank you all for your help. I couldn't post the book because of the data within it.

I found the answer... I have done far too much formatting of full columns and Excel saw them as used!. I used the following link as an Add in to solve it:

http://support.microsoft.com/kb/244435

This cleared all unrequired formats.

Thanks for your help though.