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
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
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
Dear Group,
Need Assistance for folowing Problam
active cell value is Number(or)text(or)Formula Should show as a msg box by
using Macro
*Thanks & Regards,*
*Venkatesan C*
--
--
Some important links for excel users
