SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Expand selected range in Excel using DDE.

Reply
N/A
Posts: 0

Expand selected range in Excel using DDE.

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
Ask a Question
Discussion stats
  • 0 replies
  • 124 views
  • 0 likes
  • 1 in conversation