Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
OK I did a big stuped. I was trying to save a bit of time in going to each
cell and converting it to a array by using thr ctrl-shift-enter. Not thinking I decided to save some time and highlight a section of cells then use the ctrl-shift-enter. After figuring out my blunder I went in to change the cells back to the correct formula, but get the "cannot change a array" error. How do I turn off the array on these blocks of cells? -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to validate data entries to be unique within an array | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |