Read Only Visible Columns from a range

[ravinder_tig]

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

[xls]

pl post all code for clearity.