ERROR Selection.Insert Shift:=xlDown

[goncalo_2697]

Hello everybody,

CROSSPOSTED here: https://www.mrexcel.com/board/thread...ldown.1225839/

I'm trying to run the following code to add one empty line, but it only works if I run the macro as soon as I open the excel:

Please Login or Register  to view this content.

If i change anything in the file after open it up and before run the code, I get the error attached.

Thanks for your help!

[Glenn Kennedy]

Thanks. A pity you didn't read the other rules, too...

https://www.excelforum.com/forum-rul...rum-rules.html

Rule 3

We have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

1) if you have cross-posted, and

2) the URL of the cross posts.

That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.



However, since you are either a new member or a very infrequent user, on this occasion, I have done it for you. Is it cross-posted anywhere else?

[goncalo_2697]

Hi Glenn,

There you go:
https://stackoverflow.com/questions/...t-shift-xldown

Thanks a lot!

[Glenn Kennedy]

Thanks. Thread OPEN again. I edited the spaces out to make a live link.

A word of advice.

If I see that someone has posted the same query on ONE site, I will check to see if it has been answered or not before looking further at the problem.

If I see it has been posted on MULTIPLE sites, I will usually ignore the thread and do something else.

It can be a bit off-putting to see that it's everywhere on the interweb.

I'll not be helping further... but only 'cos I know nothing about VBA.