LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Find cells question ?

thanks , Seem Work. ....

Mario


"Jim Rech" escribió en el mensaje
...
Perhaps...

MsgBox Cells(65536, ActiveCell.Column).End(xlUp).Address

--
Jim Rech
Excel MVP
"Mario Reiley" wrote in message
...
| Thank for respond me but there is a little problem
|
| this way : Application.CountA(ActiveCell.EntireColumn) leave the empty
cells
| without count.
|
| I need to find the last cell in the entire column with data..
|
| You know another way ?
|
| Best regard
| Mario
|
|
| "Jim Rech" escribió en el mensaje
| ...
| MsgBox Application.CountA(ActiveCell.EntireColumn)
|
| --
| Jim Rech
| Excel MVP
| "Mario Reiley" wrote in message
| ...
| | Hi, Group
| |
| |
| |
| | How can I find the how many cells fill in entire column are?
| |
| |
| |
| | a.k In the cell A1 how many cells to have data.
| |
| |
| |
| |
| |
| | Best regard
| |
| | Mario
| |
| |
|
|
|
|




 
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
How do I find my question? billnock Excel Discussion (Misc queries) 4 February 15th 10 07:59 AM
Need Cells.find to find first number in a row which is 8000 Kasper Excel Discussion (Misc queries) 9 December 15th 08 02:10 PM
how to find my question jonsey35 Excel Discussion (Misc queries) 2 August 10th 06 06:00 PM
I have question.. I have problem with Cells.find Andrzej New Users to Excel 0 May 27th 05 03:26 PM
VBA .Find question Mark1 Excel Discussion (Misc queries) 6 December 3rd 04 08:29 PM


All times are GMT +1. The time now is 06:07 AM.

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"