Find cells question ?

[Mario Reiley]

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

 

[Bob Flanagan]

Select the range and then use selection.cells.count.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Jim Rech]

MsgBox Application.CountA(ActiveCell.EntireColumn)

--
Jim Rech
Excel MVP
| 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
|
|

 

[Mario Reiley]

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]

Perhaps...

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

--
Jim Rech
Excel MVP
| 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" <[email protected]> escribió en el mensaje
| | > MsgBox Application.CountA(ActiveCell.EntireColumn)
| >
| > --
| > Jim Rech
| > Excel MVP
| > | > | 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
| > |
| > |
| >
| >
|
|

 

[Tom Ogilvy]

Dim rng as Range
set rng = cells(rows.count,activecell.Column).End(xlup)
rng.Select

 

[Mario Reiley]

thanks , Seem Work. ....

Mario