Set Lrow by dialog box? & Loop batch size limit

[Rookeby7]

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

 

[sykes]

Can't comment on the reliability, but as for the lrow...

lrow = InputBox("Enter the list number!")
MsgBox lrow

Msgbox is just to demo output of inputbox.

 

[Rookeby7]

Thanks very much. I think I will use "inputbox" quite a lot in future - very useful, but not widely publicised

 

[sykes]

Pleasure! Thanks for the feedback.