A list of current data (AH), I wanted to use two inputbox input threshold, will be within a certain range of data filtered reflected in the K column, such as greater than 5 less than 40 for "05-40"
Try to get the smallest interval
Will make a gain inputbox input values, a comparison with RC [24]
Try:
1. The RC [24] & gt; A
2. RC [24] & gt;" "A", "
3. The RC [24] & gt;" A "
RC [24] & gt; 4. & A
5. RC [24] & gt;" "" "& amp; A



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Sub Macro7 ()

Dim As a String

A=InputBox (" begin ", "zyh")

Selection. Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Application. Goto the Reference:="R6C11: R1200C11
"Selection. FormulaR1C1=_
"=the IF (RC [24] & gt; A, "" "", the IF (RC [24] & gt;" "38" ", "" 40-65", "the IF (RC [24] & gt;" 06-38 "05", "" "" "" "" "))) "
End Sub

CodePudding user response:

:=how looks like Delphi assignment statement

CodePudding user response:

reference 1st floor SupermanKing response:

:=how looks like Delphi assignment statement

It called "named parameters,"

CodePudding user response:

5555 excel can be too difficult