• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vba small help

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
 
Ashokbioinfo


Why do you need the .Specialcells(xlConstants) ?

Have you tried it without it

Code:
Set i= Range("H7:H200")
 
Back
Top