Read Only Visible Columns from a range

Hi Guys

I'm Quite New To excel vba so need a little bit help regarding one of my problem

I do hav a sheet in which i do hav some column;s n data

Worktype
Metrics
April
May
June

in work type few rows are hidden which i don't need what i need is i want to populate only comman metrics in other range named metrics i had build a macro for this and that's working fine but the problem is it also reads metrics from hidden rows too

i had tried
a loop in which i had placed as hidden column property condition

n had used

if cell().entirecolumn.hidden=true

and 2nd is 

speical cell property

Rng.SpecialCells(xlCellTypeVisible),

Both r not working
Plz if u could help me with a macro to do this i'd be really gr8full


Regards,
Ravinder S

Hi Ravinder,

Try like this,

Sub Test()
    Dim Rng As Excel.Range
    Dim cl As Excel.Range
    
    Set Rng = ThisWorkbook.Sheets("Sheet1").Range("$A$1:$B$4")
    
    For Each cl In Rng.SpecialCells(xlCellTypeVisible)
       Debug.Print cl.Value
    Next
End Sub

Regards,
Salim.

thanks a lot Salimudheen

could u plz help me with special cell type

dose this "xlCellTypeVisible" reads the height of cell or hidden propert of cell