|
A段代码和B段代码效果应该是一样的,B段代码是能运行的版本,只是嫌B段代码中下面的部分太繁琐,经过多方查找资料,将A段代码改成了B段代码,A段代码能运行,但是出来的结果似乎和乱码没什么区别!我不知道哪里出问题了,请各位帮我讲解讲解!感激不尽!(代码在附件中运行)
Dim a As Date, m As Integer, n As Integer, o As Integer, p As Integer, q As Integer
a = "2013-3-10 00:00"
m = Year(dd)
n = Month(dd)
o = Day(dd)
p = Hour(dd)
q = Minute(dd)
另外A段代码中,SET如果换成LET就无法运行了,找不到是什么原因。我感觉A段代码运行的结果很乱有可能是因为SET的用法弄不懂,不知道是哪里出问题了。
- Sub 代码A()
- Dim Rng As Range
- Dim Sh As Worksheet
- For x = 3 To Worksheets.Count
- With Sheets(x)
- <FONT color=red>For Each Sh In Worksheets
- Set Rng = Sh.Range("A:A").Find("2013年3月", , xlValues, 1)
- If Not Rng Is Nothing Then
- </FONT>.Rows(Rng.Row).Font.Color = vbBlack
- .Rows(Rng.Row + 1 & ":" & Rng.Row + 9).EntireRow.Hidden = True
- End If
- Next
- .Columns("B:C").EntireColumn.Hidden = True
- End With
- Next
- End Sub
复制代码- Sub 代码B()
- Dim Rng As Range
- Dim a As Date, m As Integer, n As Integer, o As Integer, p As Integer, q As Integer
- a = "2013-3-10 00:00"
- m = Year(dd)
- n = Month(dd)
- o = Day(dd)
- p = Hour(dd)
- q = Minute(dd)
- For x = 3 To Sheets.Count
- With Sheets(x)
- <FONT color=red>For Each Rng In .Range("a:a")
- If Rng = a Then
- </FONT>.Rows(Rng.Row).Font.Color = vbBlack
- .Rows(Rng.Row + 1 & ":" & Rng.Row + 9).EntireRow.Hidden = True
- End If
- Next
- .Columns("B:C").EntireColumn.Hidden = True
- End With
- Next
- End Sub
复制代码 |
|