• 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.

for next loop?

usr7501

New Member
Hello,

I am new to this and my question is posted with humble and kindness. I have tried this several times but get stuck. I am curious if it is possible to make the enclosed file to a for-next loop?

I got helped with a while loop.

Bless you all.
 

Attachments

  • Test.xlsm
    33.3 KB · Views: 3
Can you please in simple English explain what you are trying to do?
Don't worry about the VBA Code, just explain what you are trying to achieve with your data ?

Which worksheet is the source data?
 
I am trying to make a for-next loop insteard of the loop I have now. I have cleaned it up.
 

Attachments

  • Test2.xlsm
    26.3 KB · Views: 3
I think you misunderstood what Hui was asking of you. Instead of providing us with a Macro that does not suit you, tell us step by step in simple English what the steps you would do manually that you wish to have VBA do. With this information in hand we can then design for you an efficient macro that achieves what you want. We are Excel experts here, but we are not mind readers. Help us to help you by giving us specific information that we can convert to a successful solution.
 
It works but the next-foor loop is better suited. It is no critique and i do not criticise your expertise.

1) hello message box
2) inputbox
3) the entry in the input box goes into the for next loop.
 
Back
Top