Okey finally i have able to solved it.
i have another uncertain issue now in Excel 2007, some time a blank error
dialog box display. with title 'Mirosoft Visual Basic' during robbon load.
Exprets, what problem may be?
Divaker
On Mon, Nov 12, 2012 at 3:54 PM, Divaker Pandey
Hello Exprets,
I am struggling with the following strange problem in MS Excel 2007 (rarely
occurs).
I have an excel Application with a userdefined ribbon built in using xml.
Suddenly, during loading application i get an error message.
= The message box that appears has no words, number or any
Prince ji happy diwali,
i thing me want to share wid u why u always share wid new mail, why dont
wid related quary?
thanks
On Wed, Nov 14, 2012 at 8:39 AM, Prince prince141...@gmail.com wrote:
Hi Anjali,
Please set the below option in your workbook.
Tools - Options - Formulas -
Hi Anjali,
You can also try..
Sub Test()
Application.Calculation = xlCalculationAutomatic
End Sub
On Wed, Nov 14, 2012 at 8:39 AM, Prince prince141...@gmail.com wrote:
Hi Anjali,
Please set the below option in your workbook.
Tools - Options - Formulas - Calculation Options - Automatic -
Hi Karan,
use this CSE formula
=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8$B$1:$B$8=G3H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Nov 14, 2012 at 1:08 PM, Karan Singh karan1...@gmail.com wrote:
Dear All,
Please suggest me to
Divaker, can you post this file?
Regards,
Sam Mathai Chacko
On Wed, Nov 14, 2012 at 2:57 PM, Divaker Pandey divake...@gmail.com wrote:
Hello Exprets,
I am struggling with the following strange problem in MS Excel 2007
(rarely occurs).
I have an excel Application with a userdefined ribbon
Use the following in the XML code..
customUI xmlns=http://schemas.microsoft.com/office/2006/01/customui;
Regards,
Anoop
On Wed, Nov 14, 2012 at 11:44 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Divaker, can you post this file?
Regards,
Sam Mathai Chacko
On Wed, Nov 14, 2012 at 2:57
Thanks EB..!
Karan Singh
On Wed, Nov 14, 2012 at 7:32 PM, Excel Beginner excelbegin...@gmail.com
wrote:
Hi Karan,
use this CSE formula
=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8$B$1:$B$8=G3H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))
--
*Regards,*
*
*
*Excel
Good Quiz Keep it up.
Hope more quizes.
Pankaj Michel
On Tue, Nov 13, 2012 at 11:59 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear group,
Thanks for your participation in the quiz. There was very good response to
the quiz from the members of this forum.
Excel quiz : 250 responses
VBA