LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Rows Count of a particular column

kaon


Worksheets("Settings").UsedRange.Columns(1).Rows.C ount

works ok

your result indicates that a244 has an entry in it - possible a space

One way to check is to goto a65536 then press the ctrl & up arrow key
to see what cell is highlighte

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Count NonBlank Rows with Criteria in another column [email protected] Excel Worksheet Functions 7 May 9th 09 03:04 AM
count how many rows contain nonblank in column A and blank in colu Vic Excel Discussion (Misc queries) 5 April 8th 09 07:42 PM
Count all rows in column with data, Except rows 1-5 Gregory Day Excel Worksheet Functions 4 March 27th 08 02:58 PM
count rows in a column for looping damorrison Excel Discussion (Misc queries) 2 April 8th 07 10:30 PM
Rows Count of a particular column kaon[_23_] Excel Programming 2 August 2nd 04 02:57 AM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"