Hi,
If you have a formula in a cell, it is never considered blank, even if the
formula returns an apparent blank.
You will often get this with 'IF' formulas: eg IF(A20=5,Bing,)
If A20 does not equal 5, then the formula returns a .
But XL sees this as a zero-length string, not a blank cell.
Hi Kevin
Module 1 2 for sending emails from excel sheet, u can read further on this
link http://www.rondebruin.nl/sendmail.htm , code in sheet 1 to sort your
data when u enter
email id in column B.
On Sat, Mar 20, 2010 at 12:24 AM, KevinM kmiy...@gmail.com wrote:
Mahesh: Why do I need code
Hi,
Kindly specify your requirements for automating the reports.
Regards
Yogananda.Muthaiah
Ph : 9731237267
On 3/19/10, Shilpa Rao shilpa...@gmail.com wrote:
Hi,
Do we have any tools to automate financial reports?
--
Regards,
Shilpa
--
Thanks Mahesh,
It really worked ... But i would appreciate if the following minor
modification is possible..
I want to add SHEET 1 (a sheet in the same workbook/excel file) 3 TIMES
since count of the column is 3 .
Regards,
Kumar
On Sat, Mar 20, 2010 at 1:51 PM, Mahesh parab
Hi Kumar
Can you send sample file. you can crate copy of sheet1 3 times but the
sheet name will not be sheet1
On Sat, Mar 20, 2010 at 5:09 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Thanks Mahesh,
It really worked ... But i would appreciate if the following minor
modification is
Hi,
Try below code;
Function Spell(ByVal MyNumber)
' Last updated 03-Oct-2003
' SpellIndian (modified on 20-Sep-2003 to 1) show Rupees to
precede, and to show for 0 paise)
' ySpellRupees (on 20-Nov-2002)
' Excel UDF to spell Indian Currency -- Rupees and
But it's not a formula in the cell.
Blank cell
code loops through sees if it has a - and if it doesn't it moves to
the next.
If it does, the data in that cell is 18 digits before the removal of
the -, and 17 after.
The code does not modify the cell at all if there is no -
--