I have the following code:
Private Sub SortWorksheet(ByVal sheet As Worksheet)
Dim sStartColumn
Dim iTopRow
Dim sEndColumn
Dim iBottomRow
Dim Rng As Range
Dim sRange1 As String
.
.
.
and I am calling the function like so:
SortWorksheet (DestSheet)
I am getting a runtime error on the above line saying "Object doesn't support this property or method"
DestSheet is a worksheet variable.
Why is this code not working?