[RESOLVED] Arguments to a public sub

[isnoend07]

I have a lot of MshFlexgrids in different forms and am tired of setting the grid size to match it's rows. So I have decided to make a public sub in a bas module and just pass the grids name, but am missing something.
maybe i'm getting brain dead, but i am having trouble getting this to work

Public Sub SetGridSize(ByRef grd As MSHFlexGrid)
With grd
.Height = .Rows * .RowHeight(.Rows - 1)' use the height of the last row
End With

End Sub

I am calling it like this: In form
SetGridSize DocGrid

but am getting a "wrong arguments or invalid property assignment" message
what is wrong ?

[techgnome]

add a check to make sure that .Rows is >0 before trying to use it in the formula...

-tg

[isnoend07]

add a check to make sure that .Rows is >0 before trying to use it in the formula...

-tg

I am calling it after i set the the number of rows.
In this case:
DocGrid.Rows = 6

[techgnome]

so, what line does the error happen on?

-tg

[isnoend07]

so, what line does the error happen on?

-tg

it happens right from the call:
SetGridSize DocGrid

[dee-u]

Have you tried stepping thru the code? Is DocGrid an MSHFlexGrid?

[Pradeep1210]

Does the code work OK if this method is not in the module and rather in that form itself?

[isnoend07]

Have you tried stepping thru the code? Is DocGrid an MSHFlexGrid?

There is no stepping thru it. It happens at the call
SetGridSize DocGrid
I have also tried this: Call SetGridSize(DocGrid)
same error

[isnoend07]

I tried on another grid in the same project and the same error
I tried on another project and it worked, I am stumped

[si_the_geek]

You seem to have missed this question:

Is DocGrid an MSHFlexGrid?

Note that MSHFlexGrid is not the same as MSFlexGrid.


You should also check if there are any other routines called SetGridSize, as it may actually be a different one which is being called.

[isnoend07]

You seem to have missed this question:

Note that MSHFlexGrid is not the same as MSFlexGrid.


You should also check if there are any other routines called SetGridSize, as it may actually be a different one which is being called.

Just tried your suggestion, i thought a longshot, but
There was another SetGridSize, that was being used by an ocx
ActiveResize1_ResizeComplete. Thanks