Haven't encountered this before, what does it mean?

[MarkInHousto]

Trying to modify someone else's code:

Set ReturnArray = Application.InputBox("Select an area consisting of 3-rows and " & n3 - (n3 = 1) & _
" columns" & Chr(13) & "to report results.",

I don't get the n3 - (n3=1) part. What is it doing?

Thanks!

[Grade4.2]

This line of code could be asking the user to select an area consisting of 3 rows and n3-1 columns. n3 could be a variable that is defined elsewhere in the code and is likely the number of columns in the area that the user is selecting. The (n3=1) part might be a condition which, if true, will subtract 1 from the number of columns and display it as the second part of the prompt.

[MarkInHousto]

This line of code could be asking the user to select an area consisting of 3 rows and n3-1 columns. n3 could be a variable that is defined elsewhere in the code and is likely the number of columns in the area that the user is selecting. The (n3=1) part might be a condition which, if true, will subtract 1 from the number of columns and display it as the second part of the prompt.

The (n3=1) subtracting one if n3=1 makes perfect sense from what the code is trying to do.

I haven't found this putting an equation inside parentheses documented anywhere. Where can I read up on it?

Thanks!

[Paul_Hossler]

I haven't found this putting an equation inside parentheses documented anywhere. Where can I read up on it?

Thanks!

Not much to read up on

Sub demo()    Dim n3 As Long
    
    n3 = 1
    
    MsgBox n3               '   1
    MsgBox n3 = 1           '   True
    MsgBox CLng(n3 = 1)     '   -1
    MsgBox CLng(True)       '   -1
    MsgBox n3 - (n3 = 1)    '   2
End Sub

[Aussiebear]

So why not simply write

Set ReturnArray = Application.InputBox("Select an area consisting of 3-rows and " & 2 & _
" columns" & Chr(13) & "to report results."

rather than

Set ReturnArray = Application.InputBox("Select an area consisting of 3-rows and " & n3 - (n3 = 1) & _
" columns" & Chr(13) & "to report results.",

[SamT]

Presumably, the value of n3 is not hard coded by the programmer