Re: $$Excel-Macros$$ Fwd: Macro Help Msg Box

Hello Dear, Have a look on updated Workbook. Now you can read formula also, Note that to read formula u have to write::: sheets("sheet name").range("starting1:ending2").FormulaLocal Hope it Will Help Happy To Help :) On Wed, Apr 14, 2010 at 4:56 PM, Venkatesan c wrote: > Dear Grou

Re: $$Excel-Macros$$ Fwd: Macro Help Msg Box

Hi Venkat, You may use below macro to get this done: * Sub Text_Type() If ActiveCell.HasFormula = True Then MsgBox "Formula" ElseIf Application.WorksheetFunction.IsText(ActiveCell) Then

Re: $$Excel-Macros$$ Fwd: Macro Help Msg Box

Hello Dear, You can simply read the range,Just use this attached excel Sheet. Hope it Will Help Happy To Help :) On Wed, Apr 14, 2010 at 4:56 PM, Venkatesan c wrote: > Dear Group, > > Need Assistance for folowing Problam > > active cell value is Number(or)text(or)Formula Should sh