Excel automation insert row

  1. 2 weeks ago

    Krzysztof K

    Jul 4 Pre-Release Testers, Xojo Pro Madrid, Spain

    Hi,
    Can some one help me. I try to insert row between Row 20 and 21 with Excel automation.
    Is there some like:
    Sheet.Range(21,21).Insert ()

    Thanks,
    Kristof

    Excel.Rows("21:21").Insert
  2. Alberto D

    Jul 4 Pre-Release Testers Answer
    Excel.Rows("21:21").Insert
  3. Krzysztof K

    Jul 4 Pre-Release Testers, Xojo Pro Madrid, Spain

    Thank you Alberto
    Sheet.range("21:21").Insert - also did the job.
    I forgot to treat it as a string...

  4. Alberto D

    Jul 5 Pre-Release Testers

    You can use Rows with a number, like this:

    Sheet.Rows(21).Insert

or Sign Up to reply!