Can't think of any. Perhaps a workaround could be to generate the numerical
results returned by the ROWS and COLUMNS bit in Excel, then copy/paste
special as values (static) for use as helpers into Xcelsius.

In Excel, you could put in any cell: =ROWS($1:1)*4+COLUMNS($A:A)-5
Copy that across by 4 cols, fill down as far as required.
Then copy that 4 col range n paste special as values into H1:K1 down
in the Xcelsius sheet.

Then you could place in B1: =OFFSET($A$1,H1,)
and copy across to E1, fill down to get the same end results.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Brinto Roy" wrote in message
...
Well, though the OFFSET function is working fine,I am not being able
to use ROWS and COLUMNS,as they are not supported by Xcelssius.
How can i modify the function B1:=OFFSET($A$1,ROWS($1:1)*4+COLUMNS
($A:A)-5,) without using ROWS and COLUMNS,but with the same
functionality?? ..