Expand selected range in Excel using DDE.

[deleted_user]

When using DDE I select a range with e.g.

put '[select("r1c1: r19c5")]';

If my SAS output data would be expanded by one row is it possible to increment r19 to r20 in the above code?

Put another way: Is it possible to pass a number n to "r1c1:rnc5", where n represents the number of rows in the specific SAS output data that is produced?

Regards
Anne Message was edited by: AnneP