我不知道尚未设置什么变量。
Option Explicit
Option Base 1
Sub ReverseOrder()
Dim ReverseOrder As Variant
Dim nEmployee As String
Dim nEmployees As Integer
Dim ssn As Variant
Dim wsData As Range
Dim i As Integer
With wsData.Range("A1")
nEmployees = Range(.Offset(1, 0), .End(xlDown)).Rows.Count
ReDim Employees(1 To nEmployees)
ReDim ssn(1 To nEmployees)
For i = 1 To nEmployees
Employees(i) = .Offset(i, 0).Value
ssn(i) = .Offset(i, 0).Value
Next
For i = nEmployees To 1 Step -1
.Offset(nEmployees - i + 1, 3).Value = Employees(i)
.Offset(nEmployees - i + 1, 4).Value = ssn(i)
Next i
End With
End Sub
您变暗wsData
但未将其设置为任何对象(例如Set wsData = Range("A1:A10")
但我觉得wsData
应该成为一个Worksheet
对象
所以
Dim wsData As Worksheet
Set wsData = Worksheets("myWorksheetName") ' change "myWorksheetName" to wanted actual sheet name
然后你的代码
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句