Insterting Cells

[skate1991]

HI,

I basically have 1500 rows of data, I need to put in a line in between each row, I was just wondering if you can do it some other way then inserting in each line singularly.

Thanks

[sweep]

Hi,

This code should do what you require.

Please Login or Register  to view this content.

[skate1991]

hi Sweep,

I have tried writing that code in but it has had no effect, I opened up vba by pressing alt f11, I then entered the code and press run and nothing happend.

Any ideas mate

Thanks

[tom1977]

code is ok

check your setting on developer card "macro security"

[skate1991]

Sorry When it comes to coding I'm a complete novice what am I checking for in "macro Security"

Thanks

[skate1991]

I have figured it out