RH,

RNum is simply a variable used as a counter in the For ... Next loop. First
time through the loop it will be set to 1, 2 on the second, etc. until it
gets to the value in MRow. Typically it will be used in the loop to refer to
something else.

MRow is just a numeric value of the number input by the user at the start,
with 10 added.

--

HTH

Bob Phillips

"RH" wrote in message
...
I'm working on an Excel project and ran across this code
snippet:

###########################
temp = InputBox(prompt:="Enter the Number of the last row
shown on the screen (i.e. 1130):", _
Title:="Length of File",
Default:="2000")
If temp = "" Then
MsgBox prompt:="Convert Data Procedure
Canceled."
Range("a1").Select
Exit Sub
Else
End If
Columns("A:A").Select
Selection.Delete Shift:=xlToLeft
MRow = CSng(temp +
10) 'Converts temp from string to
number
counter1 = 0
For Rnum = 1 To MRow

##############################

So, in this case....What is RNUM? I don't understand
the "= 1 TO MROW" here.

Can someone elaborate please?

Thanks!
Bob