clark shao said Hi, Please try this one. If the count of the biggest number in range A2:D2 equals to the number of numbers greater than 0, the for...
When finding FV of an annuity we are supposed to follow this i.e. RATE = (1+ Annual Return)^(1/12)-1 instead of (Annual Return / 12) as this gives mor...
Bang on Sunny! Brilliant!
Both. I had used Worksheet_Calculate and Worksheet_Change events in my Workbook but not Worksheet_Activate event yet. This worked nicely now. Thanks.
Catalin you are awesome here! Great help. So kind of you.
Hi Phil, Thanks a ton for your suggestion. I agree with you. In my workbook there are some sheets where I want rows to get hidden automatically wh...
I got some nice insights from here May be you can also refer the above link to understand it better.
Even if you have many worksheets with different headers and footers, still you will need NOT to do it for every one of them. Say the value stored in c...
Using VBA you can write a Workbook.BeforePrint event where you can mention what is to be written in Header Footer. So even if someone writes something...
Thanks a ton Phil and SunnyKow for replying. No, I don't want to hide any sheet. All I want is to stop displaying sheet's names in the sheet tabs. Let...
Thanks Mynda and Craig for taking your valuable time out to help me. Let me clarify: 1st year 12 instalments of Rs. 5000 each was invested at st...