Reset the Limit of Rows (MaxNumShown)

[chrisg]

Hi,

i am using the following Marco to limit the number of rows:

(The limit in this example, is 1000)

sub limitRow

set chart = ActiveDocument.GetSheetObject("CH02")

'set chart = ActiveDocument.Activesheet.CreateStraightTable

'tb.AddField "Member"

set cp = chart.GetProperties

cp.TableProperties.MaxNumShown.v = 1000         

chart.SetProperties cp

SET p = chart.GetProperties

chart.SendToExcel

end sub

I would like to reset the value back to the original value.

So from '1000' to NO LIMIT. Unfortunately I have no idea how to do that.

Many Thx

Christoph

[Gysbert_Wassenaar]

Try setting it to 0. That causes it to show all records again here (using QV11.2).

[chrisg]

Hi Gysbert,

many thx - but the result is 0 (QV 10)

😞

[marcus_sommer · Accepted solution]

Set the value on true (...v. = true).

- Marcus

[chrisg]

Danke! Cool