I am looking to create a loop to do a function I created on each cell in a column of an undefined length? The fucntion (called FindMin) is a series of IF THEN statements. Thanks in advance.
Sam
I am looking to create a loop to do a function I created on each cell in a column of an undefined length? The fucntion (called FindMin) is a series of IF THEN statements. Thanks in advance.
Sam
Have you looked into a For Each ... Next loop?
For Each c In myrange
code
Next c
Look in VBA help for "For Each Next statement"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks