Excel

[RicksAtWork]

I have the following code:

Dim rng As Range
Set rng = Range("J6", "J88")

RoundRange (rng)


Where Roundrange is the following sub:



Private Sub RoundRange(rng As Range)

'currently does nothing

End Sub

I get an error on the line:

RoundRange (rng)

Even though there is no code in the sub!!!

What am I doing wrong?

 

[PHV]

I get an error
Any chance you could post the whole error message ?
What about this ?
Set rng = Range("J6:J88")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vbap]

Take the parenthesis out or use the reserve word 'Call'.

RoundRange rng

or

Call RoundRange(rng)