Set Lrow by dialog box? & Loop batch size limit

Rookeby7

New Member
Joined
Jul 5, 2019
Messages
18
I am compiling a register of projects and have been using VBA to Loop through 25-40 files in a batch.

As the list gets longer I have been manually changing this in the macro text.

1) Does anyone know if i can use a dialog box to set the Lrow, to add to bottom of list? (So I can't forget to change it)
I have:
Dim lrow As Long
lrow = 830

2) Also are the any suggestions for improving reliability of Macros to process more files in a Batch, Macros hang frequently which kills excel and needs Ending via Task Manager...
Is this normal Or am I being too impatient

Thanks in advance
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Can't comment on the reliability, but as for the lrow...
Code:
lrow = InputBox("Enter the list number!")
MsgBox lrow
Msgbox is just to demo output of inputbox.
 
Upvote 0
Thanks very much. I think I will use "inputbox" quite a lot in future - very useful, but not widely publicised
 
Upvote 0
Pleasure! Thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top