locked
For using visual basic to write an excel spreadsheet

    Question

  • Now I face a problem to add the balnk row after one loop is finished.  I want to export multiple invoice. There are many items in each invoice. So i want to add one new row after each invoice.
    Wednesday, April 22, 2009 10:01 AM

Answers

  • It would help to see your code so that we can determine how to implement the Insert. The below code is an example, but you would probably need to adapt it for your code:

        Rows("1:1").Select
        Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove



    Paul ~~~~ Microsoft MVP (Visual Basic)
    Wednesday, April 22, 2009 7:03 PM