Modify array function length

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an array function, let's say from B1 to B100.
I want to modify it to be from B1 to B50.
How can I do this without deleting the array and entering the new one?
(I need this because I have array functions in a worksheet and I want to
copy the functions to other similar worksheets where the length of the array
should be different).
 
Fabian,

Select cell B1, press F2, Shift-Home, Ctrl-C, ESC. Then go to your other worksheet, select B1:B50,
press F2, Ctrl-V, then edit the referenced ranges to the appropriate level, then press
Ctrl-Alt-Delete and reboot your machine (kidding!) - press Ctrl-Shift-Enter to enter the adjusted
array function. And you're done....

HTH,
Bernie
MS Excel MVP
 
Thanks for your help !
The only drawback is the time it takes to reboot my PC!! (kidding too!)
 
LOL! I'm sure somebody will actually do that....

Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping integers to strings 5
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Array formulas/selecting data 2
Sumif using Arrays 2
Help using the LARGE function "WITHOUT" using an array 14
Array-friendly functions 1
Percentile 1
Row references 1

Back
Top