I can select using Range("B:B").SpecialCells(xlCellTypeVisible).Selec t
1/ Is it correct to write Range("B:B") to specify I want to select the column B
2/ How can I get the max of the selected data now
Thanks for your help
Jerome

----- tinyjack wrote: ----

You can use the SpecialCells method of the Range object
and use the xlCellTypeVisible type

HT

T