ashokbioinfo
New Member
Hi,
i want to run the macro from row number R7 upto R200 as R1-R6 is having data.
dim i as range
Set i= Range("H7:h200").SpecialCells(xlConstants)
But sometimes data are not available from starting row(R7) but when I run the loop, I am getting error "no cells found". What condition i need to write to skip error.
Can anyone help me
i want to run the macro from row number R7 upto R200 as R1-R6 is having data.
dim i as range
Set i= Range("H7:h200").SpecialCells(xlConstants)
But sometimes data are not available from starting row(R7) but when I run the loop, I am getting error "no cells found". What condition i need to write to skip error.
Can anyone help me