Read/write Excel Range Names

Help
1

The read/write range activities in the Excel Application Scope work with “A1” range references. How can I use a range name to write a value into a range name reference, re-calculate the spreadsheet, then read a different range name reference.

1 Like
2

You can write the named range (queue) into the cell field of the read cell formula
image

And also a write cell:

image

3

Thanks for the tip, ewanc1. I thought I tried that. And it works!

1 Like