Insert ExcelBuffer in existing worksheet

stone1541

Hi all,

I have a problem and i'm sure you will find a solution.

The goal is ton insert the excelBuffer after an existing row in a existing Sheet ?

I thus have to insert so many lines as necessities into the sheet existing from a line.

The code:

FOR Nbr := (AfterLines+1) TO (AfterLines+1+NbrLines)
DO BEGIN
XlRange.EntireRow.Insert;
END;

How to define the line from which lines are going to fit ?

This code is ok but the inserted lines always begin in the line 1 :(:(:(

Many thanks for your help

ufuk

Search for range word in Excel Buffer table. You will find examples of starting and ending a range, naming a range and going to range.