|
问题1 "老师你好,怎么用vba代码把单元格里的公式不显示,
我用语句ActiveCell.FormulaR1C1 = Evaluate(""=MID(R2C1,COLUMN(RC[-1]),1)"")时的出来单元格不正确,
用ActiveCell.FormulaR1C1 = ""=MID(R2C1,COLUMN(RC[-1]),1)""单元格里显示公式,
请老师给我修正下,
或者优化下,
谢谢老师啦"
问题2 用vba处理a5单元格里的数值= b3里的数值切数值是绝对整数,把小数点后全部不要
问题3 "用vba处理工作表“数值表”a2,a3,a4……单元格里的数字跟据整数数值每次变化自动往下一单元添加,
如果数值重复时则不添加,如果小于第一次算出的结果时也不添加"
- Sub test()
- Dim a, i, j, arr, st, rn As Range, diction
- Set diction = CreateObject("scripting.dictionary")
- 'Sheets("Sheet2").Range("a2") = Now + Rnd * 10 '检验
- Sheets("Sheet2").Range("a2") = Now '正确
- Sheets(1).Cells(5, 1) = Int(Sheets("Sheet2").Range("a2"))
- For i = 2 To 16
- Cells(2, i) = Mid([a2] * 1, i - 1, 1)
- Next i
- arr = Range("B2:Z2")
- For j = 1 To 25
- st = st & arr(1, j)
- Next j
- Sheets("sheet2").Range("b3") = st
- Erase arr
- Set rn = Sheets(2).Cells(60000, 1).End(xlUp)
- If rn.Row > 1 Then
- arr = Sheets(2).Cells(1, 1).Resize(rn.Row)
- For j = 2 To UBound(arr)
- diction(arr(j, 1)) = ""
- Next j
- End If
- If Sheets(1).Cells(5, 1) > Sheets(2).Cells(2, 1) And Not diction.exists(Sheets(1).Cells(5, 1).Value) Then rn.Offset(1) = Sheets(1).Cells(5, 1)
- End Sub
复制代码
|
|