Excel VBA Loop Through Rows in a Table or Range

garbage change the title
not a table

what if I wanted to skip specific rows without any condition like if I want to read only rows 2,3,4 and 7,8,9 then 17 and 21. is it possible to do it?

Great vid! Solved my problem. :)

Thank you sir!! You saved me some agony today..lol

Hello everyone, need your help if anyone can share some input

I need to select 10 items in fieldname which are available in sheet 1 using vba. What code can be used?

Thank you!

Very nice! I'm very new to Excel VBA. I'm trying to assign the first row for my loop to run if a targeted cell is not blank. Would you be able to help me with this using your code model?


This is snippet of my code. It will run fine if there is a valid condition in Row2, but will not continue onto Row3 if it is not valid or blank.

Dim r As Long
Dim olInsp As Object
Dim wdDoc As Object
Dim oRng As Object
Dim mydate As Date
Dim mydate2 As Date

mydate = Date
mydate2 = mydate + 6

r = 2

Do While Worksheets("PEF").Cells(r, 15) >= mydate And Worksheets("PEF").Cells(r, 15) <= mydate2

Hi thank you for the informative video. Is there any columns can be looped as well?

Can you use currentregion to get the rows?

Where is the definition of FormatAsPhoneNumbers?