I need to use a Range variable in a Project VBA sub. I have opened Excel in another sub and set a variable to hold Excel.Application. I call a subroutine to use that instance of Excel. The Dims raise a VBA err # 438. How do I declare the Range variable to use it in the sub?
Private Sub Example(ByRef xlAppLcl As Object,
ByRef xlBookLcl As Object,
ByRef xlSheetLcl As Object,
ByRef ProcErrFlgLcl As Boolean,
ByRef ProcErrMsgLcl As String)
-->Dim xlRow As Excel.Range [I also tried xlAppLcl.Range]
-->Dim xlCol As Excel.Range
Set xlAppLcl.xlRow = xlAppLcl.ActiveCell
End Sub