In the Excel File I have named range (A2:F10)for ex "Order" in Sheet1,I use this on another worksheet Sheet2 .
In Sheet2 in cell A2 I put the formula =Order, but it displays only 1 value in the named range and not the full range of data (A2:F10)
Need help to resolve the #Value Error for the Named ranges, thanks
It is only showing the contents of the 1st cell in that range - and unless you tell it actually do anything (sum/count etc) thats all it will ever show.
If you edit (F2) and then calc (F9) on that cell, you will see all the values from that range
What exactly are you trying to do?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, what you are trying to do should work with the new excel engine and spill capabilities.Originally Posted by shals
You are on O365? what version? you need at least 1907 build 11901.20176
As a quick test, see if you have the =unique formula, if yes then the spill should work. if not then you need to update
@Joe
Administrative Note:
Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks
@shals
please update your Excel Version ( in your profile) if you are not using XL2003 anymore
Select referred to cells. Discover cells that your recipe is referring to and select them. ...
Discover and supplant. ...
Supplant spaces with nothing. ...
Supplant or Replace all. ...
Turn on the channel. ...
Set the channel. ...
Select any anonymous check boxes. ...
Select clear cells, and erase.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks