Re: $$Excel-Macros$$ HI --help me

2011-07-25 Thread vijayajith VA 
Hello All,

Thank You very much..

On Mon, Jul 25, 2011 at 12:20 PM, Cab Boose  wrote:

> Hi
>
> Get the PUP V3 utility on the J-Walk site.   Do all errors on whole sheet
> in one click.  Magic.
>
> Charlie
>
>
>
>
>
>
>
> On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI 
> wrote:
>
>>
>>
>>  Dear Vijay,
>>
>> Please find Error remover technique.
>>
>>   * Errors-World* Error Type
>> Error Remover Functions*ISNA()* *ISREF()* *ISERR()* *ISERROR()* *
>> IFERROR()*  #N/A YES YES NO YES YES   #ISREF NO YES YES YES YES  #NULL NO
>> YES YES YES YES  #DIV/0! NO YES YES YES YES  #NUM NO YES YES YES YES
>> #NAME? NO YES YES YES YES  #VALUES NO YES YES YES YES Other Errors
>># Press Alt+O+C+A  2.32335E+16 Press
>> Ctrl+1,Custom Format->Press 0  Circular Reference Formula-Error
>> checking-Select Circular Reference and Decreas formula Range
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>>
>>
>> On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA 
>> wrote:
>>
>>> Hi,
>>>
>>>
>>> I have one questions.Usually while doing reports what are errors you will
>>> get ?
>>>
>>>
>>> Thanks
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Cab Boose 
Hi

Get the PUP V3 utility on the J-Walk site.   Do all errors on whole sheet in
one click.  Magic.

Charlie







On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote:

>
>
>  Dear Vijay,
>
> Please find Error remover technique.
>
>   * Errors-World* Error Type
> Error Remover Functions*ISNA()* *ISREF()* *ISERR()* *ISERROR()* *
> IFERROR()*  #N/A YES YES NO YES YES   #ISREF NO YES YES YES YES  #NULL NO
> YES YES YES YES  #DIV/0! NO YES YES YES YES  #NUM NO YES YES YES YES
> #NAME? NO YES YES YES YES  #VALUES NO YES YES YES YES Other Errors
>  # Press Alt+O+C+A  2.32335E+16 Press
> Ctrl+1,Custom Format->Press 0  Circular Reference Formula-Error
> checking-Select Circular Reference and Decreas formula Range
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>
>
> On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
>
>> Hi,
>>
>>
>> I have one questions.Usually while doing reports what are errors you will
>> get ?
>>
>>
>> Thanks
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread NOORAIN ANSARI 
 Dear Vijay,

Please find Error remover technique.

  * Errors-World* Error Type   Error
Remover Functions   *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()*
#N/A YES YES NO YES YES  #ISREF NO YES YES YES YES #NULL NO YES YES YES YES
#DIV/0! NO YES YES YES YES #NUM NO YES YES YES YES #NAME? NO YES YES YES YES
#VALUES NO YES YES YES YES Other Errors # Press
Alt+O+C+A 2.32335E+16 Press Ctrl+1,Custom Format->Press 0
   Circular
Reference Formula-Error checking-Select Circular Referenceand Decreas
formula Range


-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 



On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:

> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Sant Ram 
use formula
=IF(iserror(ur formula),"",ur formula))

On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:

> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards,
Santy

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Rajan_Verma 
1)  Duplicate Unique Key

2)  Blank Cells

3)  Wrong Data/time format

4)  Wrong Data Type (Number to String)

5)   

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 24, 2011 5:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HI --help me

 

Hi,

 

 

I have one questions.Usually while doing reports what are errors you will
get ?

 

 

Thanks 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread KAUSHIK SAVLA 
It depends upon the mistakes u do.

On 7/24/11, vijayajith VA  wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
Sent from Gmail for mobile | mobile.google.com

Kaushik Savla

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Dilip Pandey 
Hi Vijayajith,

It depends which report having what kind of formula / function /
macros you are working on.

I have came across following errors so far:-

1) Excel Function errors -> Can be corrected using ISError function(s)
2) VBA Macros -> Can be prevented using Error handlers
3) Linking errors -> if other sheets / databases are linked in your
excel report.

There are errors but there are solutions as well.  So cheers :)

Regards,
DILIPandey

On 7/24/11, vijayajith VA  wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread ashish koul 
http://www.ozgrid.com/Excel/formula-errors.htm

http://chandoo.org/wp/2009/04/20/excel-formula-errors/


On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV  wrote:

> Hi Vijay,
>
> In Excel You May get errors are
>
> #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
> if u want avoid this Tou may us IFERROR or IFERROR ISERROR  Function
>
> *Best Regards,*
> *Venkat*
>
>
> On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
>
>> Hi,
>>
>>
>> I have one questions.Usually while doing reports what are errors you will
>> get ?
>>
>>
>> Thanks
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *
> *
> *Chennai*
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Venkat CV 
Hi Vijay,

In Excel You May get errors are

#NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
if u want avoid this Tou may us IFERROR or IFERROR ISERROR  Function

*Best Regards,*
*Venkat*


On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:

> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*Chennai*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ HI --help me

2011-07-24 Thread vijayajith VA 
Hi,


I have one questions.Usually while doing reports what are errors you will
get ?


Thanks

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel