Strange result inserting row

[Gregfox]

Hi all I've worked 2 hours trying to determine the problem with the following simple code:

Sheet1.Rows(3).insert      'Insert a new row at Row3

When I run it on a blank workbook/worksheet it works just fine, however when I run it on a

workbook/worksheet with data it just passes (in single step) this code and does nothing. ??
Using 2007 on a PC non-protected workbook.

​

 

[RoryA]

What did the message say when you tried the code I suggested?

 

[Gregfox]

It had no message and I was able to step through it, but no new line.
I'm pretty happy with what I have now.

 

[RoryA]

Ok (but you couldn’t not get a message with the code I suggested as that’s all it was!)

 

[sericom]

Did you try this?

Sheets("SUN").Rows(3).insert

 

[Gregfox]

Yes, and the program stepped through it but no line was inserted, there must me something stopping this code from executing. The code I posted did work and I think it's time to move on.
Thank you for you aid!