Replace Application.InputBox with a string.

[bbmak]

I got this code over the internet, and I modify a bit to fit my needs.
There is one thing I don't really know how to get rip.
I want to replace the application.inputbox part with my own string there. I do not want the user input anymore. However, I do not know really know how to do that part. Can anyone please help.

Please Login or Register  to view this content.

[shg]

E.g.,

Please Login or Register  to view this content.

[LJMetzger]

Hi bbmak,

Welcome and thanks for putting in code tags.

In the line that follows, the '8' at the end means that InputBox is not returning a string, but a range of cells. It appears that the 'range of cells' is really only one cell.

Please Login or Register  to view this content.

In the context of your macro, the line would be replaced by something like:

Please Login or Register  to view this content.

I hope this helps.

Lewis

[bbmak]

Thank guys, I got it.