ravinder_tig
06-16-2009, 09:13 PM
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
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