Excel Add-in function

Question

Hi Everyone,

I'm working on a report in excel using Board Add-in.

Just wondering if there is any syntax or macro function that can get the current selection?

I'm looking into the help section but couldn't find anything

Thanks,

Chi

Previous Member · Answer

Hi Chi Ly,

check out Office add-in excel, keep format

There is a what's called Substitution formulas named '@Selection'

With that you should see the value of the selection as text in a cell.

Make sure that the type of the algorithm is text

The result in Excel then could look like this:

BR, Ray

Björn Reuber · Answer

Hi,

if you want to display the current selection, just add an @Selection to the layout header

regards

Björn