Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cww3
  • Order by date
  1. cww3

    Loop through range of cells in a macro?

    Thanks everyone! Actually, I had to do was change a line of ck1999's code to: wb.SaveAs "sample" & counter + 699 & ".txt", FileFormat:=xlText 'for filename Thanks again :)
  2. cww3

    Loop through range of cells in a macro?

    Hi Skip, Thanks, but can you explain where/how I would change that? I've never used Visual Basic before. Thank you!
  3. cww3

    Loop through range of cells in a macro?

    Hi ck1999, Thanks, that was very helpful! Do you know if there's a way for me to save the new files as *.txt files instead of *.xls? I tried just changing it in the code from ".xls" to ".txt" but the text file opens up with a bunch of gibberish.
  4. cww3

    Loop through range of cells in a macro?

    Hi Skip, What I meant is that I don't want C1:BF1 and C116:BF116 to change. I have 3 rows that are being pasted into new documents, and rows 1 and 3 (C1:BF1) and C116:BF116) never change. Only row 2 (C2:BF2) is supposed to change to C3:BF3, C4:BF4, C5:BF5, etc. That's not what your code does...
  5. cww3

    Loop through range of cells in a macro?

    Hi, Right now this macro selects cells beginning in C1, C2, and C116. How do I write a loop just for the C2 cells so that subsequent iterations will use C3:BF3, C4:BF4, etc. while maintaining C1:BF1 and C116:BF116? In other words, the rows that would be copied and pasted would be: Document...

Part and Inventory Search

Back
Top