Alter value in macro

[Orum]

Hello,

I have a nice macro that changes one column into several columns. The problem is I have to step into the macro to alter the number of rows the column goes into. The value I want to change in the seventh for down in the below macro (No_row = 40)
Is it possible to add a number box in the sheet that alters the value without stepping into the macro? It would be great to have it in the quick access toolbar but not essential.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

[Leith Ross]

Hello

Welcome to the Forum!

Posting a copy of your workbook is the best and fastest way to get your questions answered. If your workbook contains sensitive information, please redact it before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[jmac1947]

Hi Orum and welcome to the forums

If I understand your request maybe something like this simple input box could help

Please Login or Register  to view this content.

[protonLeah]

No_row = Application.Inputbox("Enter rows to copy",Type:=1)

[Orum]

Thanks for you reply guys. Very helpful.

Paul

[Orum]

That works perfectly B. Johnson.
Thank you so much that is a big help. Simple when you know how.

Many thanks
Paul