Setting an MSHFlexGrid to nothing

[mel_flynn]

How can I set the MSHFlexGrid to Nothing? i.e. Before I reload it I want to set it to Null or Nothing

The reason being:
When I load the grid initially there is no problems, but (only sometimes) when i reload it I get an Automation Error. I never get this error when I'm doing th initial load.

I have tried:
Grd.Collapse
Grd.Refresh
Grd.Clear
Grd.ClearStructure

You cannot:
Set Grd = Nothing
Set Grd = Null

Any suggestions?

[mel_flynn]

Someone?

[TheBionicOrange]

Set the number of rows back to zero.

If you have fixed rows allow for these, i.e. if you have 1 fixed row set the rownumber back to 1 etc ...

[mel_flynn]

It's when I am setting the .Rows = 0 that the Automation Error is triggered. That's why I want to set the Grid to Nothing before I set the Rows to 0

[TheBionicOrange]

Do you have any fixed rows ?

If so setting the .Rows property to zero WILL cause an error.

Sorry if I am sounding obvious, but thought I would check.

[mel_flynn]

Yes I have .FixedRows = 1 but I tried to set it to 0 before I set .Rows to 0