object browser assistance 1

[mscallisto]

From within the object browser (F2) I can see the class "Applications" and a member "ActiveSheet"

Now I wish to see all the members of ActiveSheet like UsedRange, Cells(,) etc., and so on and what each does.

Excel Help isn't helping!

 

[PHV]

Click Worksheet in the Class column.

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

 

[mscallisto]

Yes that does help very much, to a point.

From worksheet I can see the members: Rows, Range, UsedRange etc. How do I continue to see the members of Rows etc.?

 

[PHV]

Click the green underlined comment, like this:
Property Rows As [green]Range[/green]

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

 

[mscallisto]

OK Now you can have a star...thanks very much PH

sam

 

[mscallisto]

trying to get the "used rows count" for one or more (but not all) columns I tried:

usedrows = ActiveSheet.UsedRange.columns("t:t").Rows.Count

It doesn't compute, is there a way to do this?

 

[mscallisto]

After reading FAQ219-2884 I guess I should ask this in a new thread.