Removing Input Box from Macro

**luckyajr** · 02-10-2012, 02:00 PM

Hi All,

Thank you in advance for taking your time to review my post.
I have the following code which someone helped me out with. However, with this macro I am wanting to remove the Input Box that pops up and requires the user to hit 'enter' everytime the macro runs. Instead, I would like the macro to automatically insert the rows based upon the value of cell A1 without having to confirm with the Input Box.

Please Login or Register  to view this content.

Because I am such a novice with coding, if the response could be in a form where the entire macro code is spelled out instead of a suggestion on what needs to be changed, it would be greatly appreciated. That way I can just copy and paste the macro response instead of having to try and figure out how to apply your suggestions to my existing code. Thanks!!

**TMS** · 02-10-2012, 02:21 PM

Cross posted and answered here.

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

**Winon** · 02-10-2012, 02:24 PM

Have you cosidered what the implications might be, if "trash" was enterd into Cell A1 withoutit being confirmed as correct?

**luckyajr** · 02-10-2012, 06:26 PM

I also posted this question http://www.mrexcel.com/forum/showthread.php?t=612643.

Thanks for the replies. There will not be an instance when something that would be "trash" would be in cell A1 as the cell is based on a formula and this macro would not even be run if cell A1 was not a number.
Thanks.