viomman
03-04-2009, 09:48 AM
Ok I am seeming to have many problems today
I am trying to pass a cell value to another subroutine. Does any one have any idea as to how to declare this and pass it to the next routine to use
here is the first code
If rBLoopCells.Value > 0 Then
With rBLoopCells
ActiveCell.Select
.Offset(-1, 0).Select
ActiveCell.Select
YrVal = ActiveCell.Value
ResetFound
Call ResetFound
Ok so the YrVal is the value i want to pass to the ResetFound routine to use it this way
If rBLoopCells.Value > 0 Then
With rBLoopCells
ActiveCell.Select
.Offset(-1, 0).Select
ActiveCell.Select
YrVal = ActiveCell.Value
ResetFound
Call ResetFound
Any Ideas????
I am trying to pass a cell value to another subroutine. Does any one have any idea as to how to declare this and pass it to the next routine to use
here is the first code
If rBLoopCells.Value > 0 Then
With rBLoopCells
ActiveCell.Select
.Offset(-1, 0).Select
ActiveCell.Select
YrVal = ActiveCell.Value
ResetFound
Call ResetFound
Ok so the YrVal is the value i want to pass to the ResetFound routine to use it this way
If rBLoopCells.Value > 0 Then
With rBLoopCells
ActiveCell.Select
.Offset(-1, 0).Select
ActiveCell.Select
YrVal = ActiveCell.Value
ResetFound
Call ResetFound
Any Ideas????