Passing a Worksheet to a subroutine
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:
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?
Disregard, apparently in VBA the subroutine has be called like this
Hey, I'm a C/C++/C# guy! :)