$$Excel-Macros$$ Other than Active Cell clear. ClearContents

2016-12-31 Thread Chandru
Dear all, I have basic Query , i have to enter D: D column only, D2 has some vlaue , D8 has value i am going to enter cell D5 . if going enter Any cell of D Column above and below Cell should be ClearContents automatically . could you please help me . Chandru -- Are you =EXP(E:RT

$$Excel-Macros$$ Need Help

2014-11-23 Thread Chandru
I need Excel formula or VBA for the following. *) To set cell width(for headers). *) To make hyper link text blue. *) Font Formatting(for headers). Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-10-05 Thread Chandru
Hello All, I Am Chandru from Chennai and I work at Logitek. Regards, Chandru On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi wrote: > Hey Sanjay.. > > warm welcome.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > >

Re: $$Excel-Macros$$ Multiple Find and Replace in Textboxes - Issue with multilines

2010-12-25 Thread Chandru
-- Thanks a lot. Wish you and all a Merry Christmas and Happy New Year Regards Chandru On Fri, Dec 17, 2010 at 5:15 AM, roberto mensa wrote: > I'm not sure of having understood, > try: > > Sub MFR_Textbox() > Dim Wks As Worksheet

$$Excel-Macros$$ Re: On Time

2010-11-22 Thread Chandru
Hi, Any help please Chandra Shekar wrote: > Hi, > > When I run the program excel starts flicekring how to avoid this. > > Thanks > > Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ How to attach file

2010-11-19 Thread Chandru
Hi, How to attach file in this group Thanks Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN grou

Re: $$Excel-Macros$$ VBA Code Required

2010-11-12 Thread harish chandru
Hi All, Can anyone help me providing the code for sending an excel attachment to be automatically updated in the Lotus notes in a Text format(Not as a Pictorial image or bit map. Thanks, Harish -- -- Some important

$$Excel-Macros$$ Openings in Bangalore

2010-11-11 Thread Chandru
Hi I am looking for reporting job in Bangalore. Let us know if any. Chanra Shekar B 98459 76015 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exc

Re: $$Excel-Macros$$ Help: Removing duplicate data

2010-09-23 Thread Chandru
Hi, See the attached file for details. Chandru On Thu, Sep 23, 2010 at 2:07 PM, janet dickson wrote: > Hi All, > > Team, see attached file, please help me on how to remove duplicates in .xls > file. >

Re: $$Excel-Macros$$ Extract the text from Textbox and return back after editing

2010-09-20 Thread Chandru
ul. There is a small piece of code for ungrouping the shapes but I am not able to integrate it with the main code. Thanks Chandru On Mon, Sep 20, 2010 at 11:21 PM, Paul wrote: > Let's try again. > > Please post (or send) a file that contains your work so far, > and with grouped

Re: $$Excel-Macros$$ Extract the text from Textbox and return back after editing

2010-09-20 Thread Chandru
Dave/Paul Can you look into this one and help me. Regards Chandru On Sun, Sep 19, 2010 at 5:25 PM, Chandru wrote: > Dear Experts > > I have now obtained the code the extract text from shapes and comments > in a workbook to a new sheet with all the details of the shape > ob

$$Excel-Macros$$ Extract the text from Textbox and return back after editing

2010-09-16 Thread Chandru
in advance Chandru -- -- 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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-11 Thread Chandru
ion). Once again thanks for your interest. Regards Chandru On Sat, Sep 11, 2010 at 9:23 PM, P.VIJAYKUMAR wrote: > Hello, > I want to know how you created text box in excel.In that only real problem > lies. please tell me how you create the text box in excel. > > > > Regards >

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-11 Thread Chandru
various cells and text boxes. To show the client what I have changed, I use track changes in word and that is perfectly working. When it comes to excel, track changes is ok with the cells but not with the text boxes. The file I get has lots of text boxes) Regards Chandru On Sat, Sep 11, 2010 at 1

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-10 Thread Chandru
The final conclusion is text box gets locked during track changes. Thanks for the info. On Fri, Sep 10, 2010 at 9:50 AM, P.VIJAYKUMAR wrote: > Hello, > > You can use change tracking to log details about workbook changes every time > that you save a workbook. This change history (change history: I

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-09 Thread Chandru
k OK. Now try editing the text box. Thanks for your valuable time. Regards Chandru On Thu, Sep 9, 2010 at 12:41 PM, P.VIJAYKUMAR wrote: > Hello, > In the protect and share work book in the review menu the allow sharing > option was selected .When I deselected the option  I was able

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-08 Thread Chandru
enu. > > On Sat, Sep 4, 2010 at 7:50 PM, Chandru wrote: >> >> Hello >> >> I am enabling the track changes option in Excel 2007 (Review > Track >> changes > Highlight changes). >> The option allows to track the changes made inside the cells but when >&

$$Excel-Macros$$ Track changes inside text box in Excel

2010-09-04 Thread Chandru
o edit the comments. Basically it is locking the text box and comments. Any thoughts on this strange behavior of excel. Regards Chandru -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

$$Excel-Macros$$ Pivot Table

2010-07-29 Thread Chandru
Hi, In the below code I have vba code which get student wise report using pivot table. Here I need chart with report also. Thanks in advance. Sub pivot2_creation() Dim pvt_che As PivotCache Dim pvt_tbl As PivotTable Set Rng = Sheet1.UsedRange Set pvt_che = ThisWorkbook.PivotCaches.Create(xlDatab

Re: $$Excel-Macros$$ Re: $excel-macros$ help

2010-07-22 Thread Chandru
Dear Kishan Reddy This is a very good tip and many thanks for sharing the same. I knew about excel clip board for many years but this idea of using "Paste all" to combine all sheets is really a magic. Thanks Chandru On Thu, Jul 22, 2010 at 11:36 AM, Kishan Reddy, K < kishan

$$Excel-Macros$$ Hi Help in Excel

2010-01-25 Thread harish chandru
Hi All, May I kindly request you to help me out on the below attached spreadsheet query.. I need it today as i need to submit this tomorrow morg in my class.. please help me.. Thanks, Harish -- Forwarded message -- From: Vinu Date: Mon, Jan 25, 2010 at 9:48 PM Subject: xl To: ha