Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

How to find out how many rows do my collumn have?

Hi!

I have to find out how many rows do my collumn have.
Can enyone give me som VB solution?

I tried:
Range.Rows.Count byt then I obtain 65K
and
Range.Parent.UsedRange

any others propositions??

Thanx in advice Leon!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get data from specific collumn	KT	Excel Worksheet Functions	4	September 26th 08 12:28 PM
look up and return data in collumn	Aaron	Excel Discussion (Misc queries)	1	April 21st 07 11:28 PM
counting if data from one collumn is present in another collumn	Amelia	Excel Worksheet Functions	1	February 8th 07 10:05 PM
looking for a value in a collumn	exceluser2	Excel Worksheet Functions	5	February 8th 06 11:53 PM
Looking up data within a collumn	Demitre	Excel Discussion (Misc queries)	3	December 21st 05 01:08 AM

All times are GMT +1. The time now is 11:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us