Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: Sara Lee [mailto:lee.sar...@gmail.com] 
Sent: 09 September 2012 7:41
To: Rajan_Verma
Subject: Re: macro for pivot

 

once i copy and paste into a new module, how to run  this macro?

how do i link this code to the spreadsheet i am working on?

Can you please give exact steps

On Sun, Sep 9, 2012 at 8:14 AM, Rajan_Verma <rajanverma1...@gmail.com>
wrote:

You can copy paste this code , if dost not  work , post you query on group
then with your original data. J

 

 

Regards

Rajan verma

+91 7838100659 <tel:%2B91%207838100659>  [IM-Gtalk]

 

From: Sara Lee [mailto:lee.sar...@gmail.com] 
Sent: 09 September 2012 6:39
To: Rajan_Verma
Subject: Re: macro for pivot

 

Can i copy and paste this code on any file with pivot and slicers. If not ,
how would i change the code accordingly? i am null with VB. please advise

On Sun, Sep 9, 2012 at 8:04 AM, Sara Lee <lee.sar...@gmail.com> wrote:

Thank you. i will posit it from here on.

 

On Sun, Sep 9, 2012 at 8:03 AM, Rajan_Verma <rajanverma1...@gmail.com>
wrote:

See the attached file..

You can also post this on group 

 

 

Regards

Rajan verma

+91 7838100659 <tel:%2B91%207838100659>  [IM-Gtalk]

 

From: Sara Lee [mailto:lee.sar...@gmail.com] 
Sent: 09 September 2012 6:22
To: rajanverma1...@gmail.com
Subject: macro for pivot

 

Can you help on this?

 

, when i have pivot slicers in excel 2010 and i click on few slicers, there
might be no data in my source data,

 

in that scenario- when no data, i do not want the pivot to show even the
pivot table structure. I want the excel to show message -"no data" without
any table structure or column headings- when when no data available

Can i get a macro for this? please help

 

 

 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


Reply via email to