Hard coded number range into a function

**bigdavediode** · 04-10-2009, 11:45 AM

Donkeyote -- thanks! Is it four dots, ie {1....70} ?

I just couldn't get that into the formula previously.

**DonkeyOte** · 04-10-2009, 11:46 AM

No ... the dots were meant to represent the fact that you would need to manually type all integers from 1 through 70 into your inline array constant as you had indicated in your first post... if you could do it shorthand wouldn't we have done it ?

**bigdavediode** · 04-10-2009, 12:09 PM

Thanks once again Donkey.

What an odd omission from Excel!

Hard coded number range into a function

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Hard coded number range into a function

Re: Hard coded number range into a function

Re: Hard coded number range into a function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions