using for loop for vba

by

Can you please try this? Idea would be something like this.

Dim FileNo As String

For i = 1 To 35
FileNo = "File" & i
Windows(FileNo).Activate

'Rest of the code
Next

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Excel VBA – A general how to
  3. VBA code required for Msg Box when two value equal in two cells
  4. Find text and show value if condition is met
  5. Excel check len string separated by comma [closed]
  6. How can I insert variable into formula in VBA
  7. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  8. Excel column number from column name
  9. Pop up the Excel Statusbar?
  10. VBA – destroy a modeless UserForm instance properly
  11. How To Speed Up VBA Code
  12. Execute a command in command prompt using excel VBA
  13. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  14. Copy data from another Workbook through VBA
  15. Excel VBA Load worksheet in Function
  16. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  17. Load csv file into a VBA array rather than Excel Sheet
  18. Insert line break in wrapped cell via code
  19. Change color of certain characters in a cell
  20. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  21. VBA Macro crashes after 32000 rows
  22. How to break a long string into multiple lines
  23. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  24. simple vba code gives me run time error 91 object variable or with block not set
  25. Calling regasm without administrative rights for COM interop in Excel VBA
  26. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment