Loop through Macros Until Reaching Blank Cell

[forrestgump1980]

Hi all,

I am trying to create code to run through Rules in column 'A' until the code reaches a blank cell. I want the code to Identify the the rule in the first cell e.g. Cell A8 which activates a macro e.g. Rule8(). I then want the code to move onto cell A9 and for the code to do the same i.e. identify the rule in the cell e.g. Rule52 and then run macro Rule52 (). This would work until it reaches a blank cell. I tried the below but could not get this to work. I am currently researching Do Until loops. Any help would be creatly appreciated.

Please Login or Register  to view this content.

Kind regards,

James Elwell

[jewelsharma]

try this:

Please Login or Register  to view this content.

[forrestgump1980]

Hi jewelsharma,

Thanks for your help. I tried the code but encountered the following issues:- An error at point 'Cells(.Rows.Count, "A").End(xlUp).Row' and a syntax error at 'Application.Run ThisWorkbook.Worksheets("Sheet2").Range("A" & i).Value)'.I removed the '.' before the Rows to resolve the first issue.

[jewelsharma]

Sorry for the typo. try this:

Please Login or Register  to view this content.

Let me know if anything.