| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random numbers appearing, calculations showing as zero
add this line after "If Not IsEmpty(vRange(j, k)) Then"
if len(cstr(vRange(j,k)))=0 then vRange(j,k)=0 Note that the function will now ignore empty (unused) cells, but treat cells containing a blank as zero. -- Charles ______________________ Decision Models FastExcel 2.2 Beta now available www.DecisionModels.com "ophelia" wrote in message ... Thanks so much for all your help, and your hard work :) What I was wanting really was for the blanks to be treated as Zeros, is that possible? :) If not, no worries, you've already helped me out a huge amount! -- ophelia ------------------------------------------------------------------------ ophelia's Profile: http://www.excelforum.com/member.php...o&userid=33778 View this thread: http://www.excelforum.com/showthread...hreadid=535507 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table NOT showing zero value calculations | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
| Showing a unique random number w/o duplicates | Excel Worksheet Functions | |||
| How do I set up a standard form showing incentive calculations | Excel Discussion (Misc queries) | |||
Threaded Mode
