Delete #REF named ranges

Macro to Delete #REF range names

This macro will enable you to delete named ranges with #REF error in it.

Sub DeleteRefErrRanges()

'Macro Purpose: To delete any named range with a "#REF!" error in it

Dim nm As Name

For Each nm In ActiveWorkbook.Names

If InStr(1, nm.RefersTo, "#REF!") > 0 Then nm.Delete

Next nm

End Sub

Email ID validation in Excel using Javascript

Different ways of validating Email ID:

1) To validate email ID in excel

Refer this link :

Validate Email ID using VBA(excel)

2) Validating Email ID using Javascript

Refer this link :

Validation-for-Email using Javascript

PAN Number validation

Different ways of PAN validation...

Refer this links :

1) Validate-PAN in Excel

2) Validation for-PAN-number in Windows Application