|
2学分
本帖最后由 朗驰 于 2022-5-8 17:11 编辑
Dim L, M, N
K = InputBox()
L = InputBox()'' 4
M = InputBox() ' 1
N = InputBox() ' 15
Range("B4:B98").FormulaR1C1 = "=IF((A4>=1,A4<15),"",A4) "
是我想太复杂了 问题就一个 =IF((A4>=1,A4<15),"",A4) 中的数字在vba中到单元格
想达到如下效果
=IF((A&L>=M,A&L<N),"",A&L) 4 1 15 或者 =IF((A4>=m,A4<n),"",A4 ) 1 15
If K = False Then
Exit Sub
If L = False Then
Exit Sub
If M = False Then
Exit Sub
If N = False Then
ElseIf K = "" Then
ElseIf L = "" Then
ElseIf M = "" Then
ElseIf N = "" Then
Exit Sub
End If
End If
End If
End If
If Cells(K, 1) > M And Cells(L, 1) <= N Then
'If Range("A" & N)>= 1and <Range("A" & m) Then
'=IF((A4>=1,A4<15),"",A4) '
End If
end sub
诸位老师 公式变量怎么弄呢
K 起始行
L 结尾行
M 小数字
N 大数字
公式为 =if (起始行)<=小数字,(结尾行)<大数字,"",起始行
l = InputBox("", "", "")
m = InputBox("", "", "")
n = InputBox("", "", "")
Range("BK" & l).Select
Selection.FormulaR1C1 = "=IF(AND(RC[-62]>=" & m & ",RC[-62]<" & n & "),"""" ,RC[-62])"
Selection.AutoFill Destination:=Range("BK4:BK98"), Type:=xlFillDefault
|
最佳答案
查看完整内容
l = InputBox("", "", "")
m = InputBox("", "", "")
n = InputBox("", "", "")
Range("BK" & l).Select
Selection.FormulaR1C1 = "=IF(AND(RC[-62]>=" & m & ",RC[-62]
|