for-next statment

  1. S

    "Runtime error 1004" when For Next loop finishes (maybe because it hits the end of the excel file)?

    My code is supposed to open a text file (it does this fine and I havent included that code in this snippet) and then search through it for a number of things - If column is something other than "New" it should delete the entire row. Also, if column E is anything other than a value on the list I...
  2. T

    How to loop a range in for-next statement using the VBA?

    Hello, Basically, I have 5 different columns in my table (Firstname, lastname, data1, data 2 and data3. If the firstname and lastname are duplicated, I want to merge the corresponging cells. However, I have problem with the syntax of the range in the for-next statement. Can Anyone help? Below...

Some videos you may like

This Week's Hot Topics