Menu

Need help with an array

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Tom Ogilvy Tom Ogilvy is offline

Tom Ogilvy is offline

external usenet poster

Posts: 27,285

Default

Need help with an array

Still no attachment

send the file to

I appended PPI in lieu of the number once they were exhausted. (thus rather
than PA144, you get PAPPI) If you just want PPI, that can easily be fixed.

--
Regards,
Tom Ogilvy

"hotherps " wrote in message
...
Let me try to attach the file again Tom so you can see it.

Yes I do want the cell to read "PPI" if all available PACKS - QA - and
ICE are filled. But when I run the code i have values in the cells like
"PAPPI" If it is out of the range it should read just "PPI"

Thanks

---
Message posted from http://www.ExcelForum.com/

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Complex conditional summing - array COUNT works, array SUM gives#VALUE	fatcatfan	Excel Worksheet Functions	4	November 18th 09 06:41 PM
Prevent cell/array references from changing when altering/moving thecell/array	nme	Excel Discussion (Misc queries)	1	September 19th 08 01:53 PM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
combining cells and array from different sheets into an array to pass to IRR()	[email protected]	Excel Discussion (Misc queries)	3	September 11th 06 07:17 AM
variant array containing cel adresses convert to actual ranges-array	Peter[_21_]	Excel Programming	5	December 10th 03 09:50 PM

All times are GMT +1. The time now is 06:18 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement