Read all VBA populated rows

Asked

Viewed 11 times

0

Good morning,

I need to read the number of filled lines to perform a for, but some lines are blank and the function for when to find the blank line

col = Worksheets(1).Range("C4").End(xlDown).Row

    For i = 1 To col

For example : column C has 1129 lines but when it goes from line 259 to 260 this empty and it returns only up to 259

Could you suggest some alternative?

Thank you

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.