$$Excel-Macros$$ Object Hyperlin : Deletion

Hello, Could you please let me know how to remove hyperlinks linked to graphical objects (Its nearly 1000 objects) Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Object Hyperlin : Deletion

Hello, Thanks for the reply. I have nearly 1000 graphical object in the work sheet. Macro is taking lot of time to get run some times it hangs also. I have a good processor ram speed. Could you please suggest on this. Thanks in advance. Regards, Chandra Shekar B On Fri, Mar 2, 2012 at 3:34

$$Excel-Macros$$ Pivot Issue

*Application.DisplayAlerts = True End Sub Regards, Chandra Shekar B -- FORUM RULES (986+ 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

Re: $$Excel-Macros$$ Pivot Issue

Hello Rajan, Yes Pivot name is correct. Regards, Chandra Shekar B On Tue, Mar 6, 2012 at 1:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Is pivot name “BP” correct? ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar

Re: $$Excel-Macros$$ Pivot Issue

Hello, Please let me know is there any soultion for this kind of issues. Regards, Chandra Shekar B On Tue, Mar 6, 2012 at 1:58 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello Rajan, Yes Pivot name is correct. Regards, Chandra Shekar B On Tue, Mar 6, 2012 at 1:48 PM

$$Excel-Macros$$ Multi Combo Box

Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ Multi Combo Box

Hello, Could you please help me on the attached file. Thanks in advance. Regards, Chandra Shekar B On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *HI Chandru,* * * *File size will be very larege with 1000 controlls on worksheet.. I suggest to use List

Re: $$Excel-Macros$$ Multi Combo Box

Hello, Thanks all. Regards, Chandra Shekar B On Wed, May 2, 2012 at 6:56 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 2012/5/2 Rajan_Verma rajanverma1...@gmail.com Hi Chandru Please find the attached sheet, you can use list validation for that..*** * * * *Regards* *Rajan

$$Excel-Macros$$ Top Three

Hello, Could you please help me in the formula. Please find attached file. Thanks in advacne. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Top Three

Hello, Thank you very much. On Tue, May 15, 2012 at 4:14 PM, Krishna Kumar krishnak...@gmail.comwrote: Hi In G1: 3 In H2 and copied down, =IF(ROWS(H$2:H2)=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),) In I2 and copied down,

$$Excel-Macros$$ Date

Hello, Can you please help me with attached excel. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem

Re: $$Excel-Macros$$ Date

Hello, Thanks all for your reply. Formula is not working if we have difference in date. Please find attached excel for the same. Thanks in advance. Regards, Chandra Shekar B On Tue, Jun 12, 2012 at 5:15 PM, ankur ankurpande...@gmail.com wrote: Dear Chandra, Try this one DATEDIF

Re: Re: $$Excel-Macros$$ Date

Hello Ankur, Can you please send solved excel file. Thanks, Chandra Shekar B On Wed, Jun 13, 2012 at 5:51 PM, ankurpande...@gmail.com wrote: hi chandra try this TEXT(B2-A2,[h]:mm:ss) for Formula2(hr:mm:ss) On , Chandra Shekar chandrashekarb@gmail.com wrote: Hello, Thanks

Re: $$Excel-Macros$$ Date

Hello, Any help regarding this. Thanks in advance. Regards, Chandra Shekar B -- Forwarded message -- From: Chandra Shekar chandrashekarb@gmail.com Date: Tue, Jun 12, 2012 at 3:45 PM Subject: $$Excel-Macros$$ Date To: excel-macros@googlegroups.com Hello, Can you please

Re: $$Excel-Macros$$ Date

Hello Rajan, Thanks for your reply.For example If date in Cell C2 18/06/2012 14:44:04 and in Cell D2 19/06/2012 14:42:04 then formula should show 0 because as per time one day is not completed. I hope this is clear. Thanks, Chandra Shekar B On Mon, Jun 18, 2012 at 9:31 AM, ankur ankurpande

Re: $$Excel-Macros$$ Date

Hello Rajan, Thanks its working fine. Regards, Chandra Shekar B On Mon, Jun 18, 2012 at 3:08 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** ** ** =INT(B2-A2) in C2 ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros

Re: $$Excel-Macros$$ Wishing you all A Very Happy Diwali...

Hi Ashish, WISH U THE SAME Thanks Chandra Shekar B On Thu, Nov 4, 2010 at 6:08 PM, ashish koul koul.ash...@gmail.com wrote: Wishing you all A Very Happy Diwali... -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http

Re: $$Excel-Macros$$ Excel Formula for Separation of integer in Single cell.

Hi, Nice formula but its not working with this data a 958 b 951 will return same value is there any way to do this. Thanks Chandra Shekar On Wed, Nov 3, 2010 at 7:48 PM, Vishal Parihar vish.pari...@gmail.comwrote: Hi All, Today i am going to show that how we can separation of integer

$$Excel-Macros$$ On Time

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 for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ On Time

Hi, Any help please Thanks On Fri, Nov 19, 2010 at 6:07 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, When I run the program excel starts flicekring how to avoid this. Thanks Chandra Shekar

Re: $$Excel-Macros$$ On Time

Hi, Thank you for the reply, if I run this macro excel will start flickering. How to stop this please run the program and see. Thanks Regards, Chandra Shekar On Tue, Nov 23, 2010 at 1:50 PM, SUMIT VYAS svyas0...@gmail.com wrote: find herewith thanks sumit On Mon, Nov 22, 2010 at 4:29

Re: $$Excel-Macros$$ Re: On Time

other posting having different subject line. Best Regards, DILIPandey On 11/22/10, Chandru chandrashekarb@gmail.com wrote: Hi, Any help please Chandra Shekar wrote: Hi, When I run the program excel starts flicekring how to avoid this. Thanks Chandra Shekar

Re: $$Excel-Macros$$ On Time

Hi, Thanks all for the repy. On Tue, Nov 23, 2010 at 7:08 PM, roberto mensa robb@gmail.com wrote: 2010/11/23 Chandra Shekar chandrashekarb@gmail.com Hi, Thank you for the reply, if I run this macro excel will start flickering. How to stop this please run the program and see

$$Excel-Macros$$ Gnatt Chart

Hi, I have downloaded gnatt chart from web. Please can anyone explain how to do this chart in steps. Thanks Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

Hi, Pls check this site it might help you. http://www.mrexcel.com/forum/showthread.php?t=20611 Thanks Chandra Shekar On Mon, Nov 29, 2010 at 4:23 AM, roberto mensa robb@gmail.com wrote: with UDF you can not: look here: http://spreadsheetpage.com/index.php/oddity

Re: $$Excel-Macros$$ Error Handler

Hello, Thank you for your reply is there any way where I can simplify this code. Thank you Chandra Shekar On Mon, Dec 13, 2010 at 7:39 PM, Paul Schreiner schreiner_p...@att.netwrote: So.. your macro seems to be creating a new file with a name defined with wrkbk_nm1 Now, you want to check

Re: $$Excel-Macros$$ Error Handler

).Range(A1).Select Application.Workbooks(wrkbk_nm1).Worksheets(1).Columns.AutoFit Application.Workbooks(wrkbk_nm1).Close True End If End errorhandler: MsgBox File already exist Application.DisplayAlerts = True End thank you Chandra Shekar On Mon, Dec 13, 2010 at 9:17 PM, Chandra

$$Excel-Macros$$ Filter Issue

Hello, I have attached sample workbook I need a macro to do this task. In *Sheet1*I got Input Data based on *column A* I need to separate worksheets as shown in workbook. Thank you. Chandra Shekar -- -- Some

Re: $$Excel-Macros$$ Filter Issue

Hi, Is this code for my problem. Please let me know. Thanks Chandra Shekar On Fri, Dec 17, 2010 at 7:49 AM, ashish koul koul.ash...@gmail.com wrote: try this code Sub filterdata() Application.DisplayAlerts = False Dim i, j As Long For i = 2 To 6 Sheets(Sheets(1).Cells(i, 1).Text).Select

$$Excel-Macros$$ Help on Advance Formula

Hello Team, How to get unique value based on two columns in the attached file Regards, Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Re: Lock the Object

Hello, Thank you very much Regards, Chandra Shekar On Sun, Dec 26, 2010 at 2:23 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: simply select E12:J22 cells lock them then protect sheet using password so nobody can unprotect it. see the attached file n let me know if it works for u

Re: $$Excel-Macros$$ Refreshing Pivot Table using VBA Code

Hi Daniel, Thank you very much. :) Regards, Chandra Shekar B On Wed, Apr 27, 2011 at 8:37 PM, Daniel dcolarde...@free.fr wrote: Hi, Paste the following macro in Sheet1 module : Private Sub Worksheet_Change(ByVal Target As Range) 'A1:F10 is data for pivot table 1 G1:I10 is data

$$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Hi, I want Min Max and Average by using Sumproduct. My problem is I want a formula which should be based on Date and Title as shown on Column D, E F and based on Column C I need Average, Min Max Values. If I confusing pls let me know. Thanks Chandra Shekar B

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Hi Asish, Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN AVG for first record should be 100, 50 avergage should be 87.5. Can we use sumproduct for all the formulas instead of array formulas. Thanks in advanc. Regards, Chandra Shekar B On Mon, May 16, 2011 at 9

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Hi Ashish, Please find attached file. Thanks, Chanra Shekar B On Tue, May 17, 2011 at 6:09 PM, ashish koul koul.ash...@gmail.com wrote: i have made changes in the data may be because of that can you attach the sample file back On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Hi, Thanks for the reply. Can we do this without using array function. Regards, Chandra Shekar B On Thu, May 19, 2011 at 11:16 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: HI Chandra, See if it helps… Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123

$$Excel-Macros$$ Recovering corrupted excel file

Hi, Is there any way to recover corrupted excel file. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Hi, You are using array formula i.e.=MIN(IF($A$2:$A$12=E2;IF($A$2:$A$12=F2;IF($B$2:$B$12=D2;$C$2:$C$12; =AVERAGE(IF($A$2:$A$12=E2;IF($A$2:$A$12=F2;IF($B$2:$B$12=D2;$C$2:$C$12;. Is there any way to do this without using array formula. Thanks, Chandra Shekar B On Fri, May 20, 2011

Re: $$Excel-Macros$$ Recovering corrupted excel file

Hi can u expalin briefly in steps. Thanks, Chandra Shekar B On Fri, May 20, 2011 at 5:02 PM, rajan verma rajanverma1...@gmail.comwrote: Use a Function Like this ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1 On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar chandrashekarb

Re: $$Excel-Macros$$ Recovering corrupted excel file

Hi, Its a confidential file. I cannot send the file. Please let me know if there a way to recover the file. Regards, Chandra Shekar B On Tue, May 24, 2011 at 2:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Send your File.. *From:* excel-macros@googlegroups.com [mailto: excel-macros

$$Excel-Macros$$ Pivot Items

Hi, How to extract data from a pivot item. In the example I need pivot items(1) data in the same worksheet. Thanks! With pvt_tbl pvt_tbl.PivotFields(Priority).PivotItems(1).Visible = True pvt_tbl.PivotFields(Priority).PivotItems(2).Visible = False

Re: $$Excel-Macros$$ Pivot Items

Hi, Any help regarding this. Thanks!!!. Regards, Chandra Shekar B On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, How to extract data from a pivot item. In the example I need pivot items(1) data in the same worksheet. Thanks! With pvt_tbl

$$Excel-Macros$$ Time Issue

Hi, I need to check whether date and time is greater than current date and time. Please find attached file. If date and time both are blank then it should check with present time and date. Thanks, Chandra Shekar B

Re: $$Excel-Macros$$ Time Issue

and time ? Regards. Daniel *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* Chandra Shekar *Envoyé :* vendredi 27 mai 2011 15:41 *À :* excel-macros@googlegroups.com *Objet :* $$Excel-Macros$$ Time Issue Hi, I need to check whether date

$$Excel-Macros$$ VBA and Macros for Microsoft Excel 2007 by Bill Jelen

Hi, Can I get free pdf file of Bill Jelen's *VBA and Macros for Microsoft Excel 2007. *Thanks! Regards, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

$$Excel-Macros$$ Current Region

Hi, Please find attached file here I want to highlight first and last row of the region, Please let me know how to do this in VBA. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Current Region

Thanks for the reply. How to put loop if we have more than one current region. Thanks! Regards, Chandra Shekar B On Wed, Jun 8, 2011 at 8:06 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Please use this Code Sub HighLight() Dim rng As Range ActiveCell.CurrentRegion.Select Set

Re: $$Excel-Macros$$ Current Region

= 15773696: End With Next End Sub On Jun 9, 10:42 am, Chandra Shekar chandrashekarb@gmail.com wrote: Thanks for the reply. How to put loop if we have more than one current region. Thanks! Regards, Chandra Shekar B On Wed, Jun 8, 2011 at 8:06 PM, Rajan_Verma rajanverma1

Re: $$Excel-Macros$$ Current Region

In ActiveSheet.UsedRange.SpecialCells(2).Areas With objArea.CurrentRegion: .Rows(1).Cells.Interior.Color = 65535: .Rows(.Rows.Count).Cells.Interior.Color = 15773696: End With Next End Sub On Jun 10, 12:10 pm, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Thanks for the reply, I am getting output

$$Excel-Macros$$ 2003 to 2007 : VBA Code

for the current chart type. Thanks, Chandra Shekar B -- -- 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

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

in both 2003 and 2007 you can find the difference. Thanks, Chandra Shekar On Mon, Jun 20, 2011 at 11:46 PM, Daniel dcolarde...@free.fr wrote: Hi, ** ** Can you ell which macro is involved and which result is different ? ** ** Regards. Daniel ** ** *De :* excel-macros

$$Excel-Macros$$ Protect : Charts, Shapes Data

Hi, In sheet1 how to protect shape(Click here to Generate Report) only. I need complete access to graph and data. Thanks, Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

wrote: Try this right click on image and chooze size and property the select don't move or size with cells [image: image.png] On Tue, Jun 21, 2011 at 5:02 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, In sheet1 how to protect shape(Click here to Generate Report) only. I

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

to resize the plot area, change the series colors in order to get something similar. I use Excel 2010 which is still different from Excel 2007. ** ** Daniel ** ** *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* Chandra Shekar *Envoyé

$$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

Hi, I would like to learn about Bullet chart and Indicator chart(Gauge Chart). Please let me know which would be the best site to get required information. I tried in Chandoo.org(Indicator Chart) but If I use his instruction I am not getting correct output. Thanks, Chandra Shekar B

Re: $$Excel-Macros$$ Bullet Chart and Gauge Chart : Tutorial

-Chart.html http://peltiertech.com/Excel/Charts/ On Wed, Jun 22, 2011 at 11:20 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I would like to learn about Bullet chart and Indicator chart(Gauge Chart). Please let me know which would be the best site to get required information. I

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

for 2003 End If End Sub On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Can we write different code do this. Where VBA code knows which version user is using according to that it changes chart plot area. If yes please let me know. Thanks

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

Thanks! :) On Wed, Jun 22, 2011 at 9:18 PM, ashish koul koul.ash...@gmail.com wrote: try this http://peltiertech.com/Excel/Charts/ On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Pleaase can I get 2007 code to get good looking chart as 2003. Thanks

$$Excel-Macros$$ Save file

Hi, How to save excel files in a different workstation (LAN ) which is password protected. Thanks, Chandra Shekar B -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Save file

I need thru VBA. On Fri, Jun 24, 2011 at 7:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Copy and Paste ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Friday, June 24, 2011 5:02 PM *To:* excel-macros

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

. After deselecting the shapes, select only the button, again go to format and properties, and the CHECK the lock 3. Select the data range of the chart. Right-click, and in the properties, UNCHECK the lock 4. Now protect the sheet On Jun 24, 11:24 am, Chandra Shekar chandrashekarb

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

. Now protect the sheet On Jun 24, 11:24 am, Chandra Shekar chandrashekarb@gmail.com wrote: Any Ideas please. Thanks! On Wed, Jun 22, 2011 at 11:12 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi Ashish, Thanks for the reply. Still user can edit

$$Excel-Macros$$ Bullet Chart

Hi, I am trying to make bullet chart using http://peltiertech.com/WordPress/how-to-make-horizontal-bullet-graphs-in-excel/. But I am not getting output as in the link. Please let me know whats the problem in the chart. Thanks! --

$$Excel-Macros$$ Date Difference

Hi, I need a formula which need to ignore weekends. Thanks For Ex: A1=01/07/2011 - Input B1=30/06/2011 - Result1 C1=04/07/2011 - Result2 ' 02/07/2011 03/07/2011 are saturdays and sundays. -- -- Some important

Re: $$Excel-Macros$$ Date Difference

Thanks a lot :-) On Fri, Jul 1, 2011 at 6:06 PM, ashish koul koul.ash...@gmail.com wrote: try the attachment On Fri, Jul 1, 2011 at 3:50 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I need a formula which need to ignore weekends. Thanks For Ex: A1=01/07/2011 - Input

Re: $$Excel-Macros$$ Protect : Charts, Shapes Data

Hi, Please can u expalin in steps how to do this. Thanks! On Tue, Jun 28, 2011 at 9:08 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Thanks its working fine. Please can u explain in steps how to do this. On Mon, Jun 27, 2011 at 6:59 PM, Sam Mathai Chacko samde

Re: $$Excel-Macros$$ Recovery plz

How to use this software? Thanks, Chandra Shekar B On Fri, Dec 24, 2010 at 11:56 AM, Venkat venkat1@gmail.com wrote: Dear Saijt, Find below LinkDownload Software Install,It may Help you... http://www.excel-tool.com/vbarecovery.html *Best Regards,* ** *Venkat CV* On Thu, Dec 23

Re: $$Excel-Macros$$ Recovery plz

, Jul 4, 2011 at 6:32 PM, Chandra Shekar chandrashekarb@gmail.com wrote: How to use this software? Thanks, Chandra Shekar B On Fri, Dec 24, 2010 at 11:56 AM, Venkat venkat1@gmail.com wrote: Dear Saijt, Find below LinkDownload Software Install,It may Help you... http

$$Excel-Macros$$ Pivot Issue

Hi, The data is not displaying in the below code which has written for pivot. Please let me know where is the error is. Thanks in advance Sub pivot_table() Dim pvt_ch As PivotCache Dim pvt_tbl As PivotTable Dim rng As Range Set rng = ThisWorkbook.Worksheets(Formatdata).UsedRange Set pvt_ch =

Re: $$Excel-Macros$$ Pivot Issue

@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Thursday, July 07, 2011 8:15 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Pivot Issue ** ** Hi, The data is not displaying in the below code which has written for pivot. Please let me know where

Re: $$Excel-Macros$$ Pivot Issue

Thank you I got the solution. I need to know why Adddatafield is used? On Fri, Jul 8, 2011 at 9:32 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Sorry I could not able to provide data bcoz its highly confidential I ran same using run macro I think lines which I have bolded has

$$Excel-Macros$$ SaveAs

Hi, I need to SaveAs workbook without VBA code in it. Thanks, Chandra Shekar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ SaveAs

Excel Office 2003 version but code should work for any office version.* Thanks, Chandra Shekar B On Mon, Jul 11, 2011 at 7:54 PM, rajan verma rajanverma1...@gmail.comwrote: You can also save your file in xlsx format if you dont want to save your Code in Workbook.. On Mon, Jul 11, 2011 at 7:30

$$Excel-Macros$$ Books

Hi, Can anyone suggest which book will be the best ot learn Charts (Like Bullet Chart and Doughnut chart with Indication). If anyone have ebook please post it. Thanks!. Regards, Chandra Shekar B -- -- Some

Re: $$Excel-Macros$$ Books

I need book for learning chart itself. If anything is there pls send it to me. Thanks, Chandra Shekar B On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma rajanverma1...@gmail.comwrote: *Here are some good books name which are free on internet ..* * * *VBA and Macros Microsoft Excel 2010

Re: $$Excel-Macros$$ Speedo Meter Chart

Hi, Any suggestion please. On Mon, Jul 18, 2011 at 2:31 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I am doing speedo meter chart File name: Speedometer_1 but I am not getting output as Filename: Speedo_FDF0OKZGD1F4SBI which has taken from site http://www.instructables.com

Re: $$Excel-Macros$$ Books

/MicrosofExcel2007VBAMacroProgr.htm * Regards, Vikas Chauhan* On Wed, Jul 13, 2011 at 3:46 PM, jmothilal gjmothi...@gmail.com wrote: if any one have pdf file pls send me J.Mothilal On Wed, Jul 13, 2011 at 2:56 PM, Chandra Shekar chandrashekarb@gmail.com wrote: I need book for learning chart itself

$$Excel-Macros$$ Extracting data from Website

Hi, How to extract data from websites for ex: Yahoo News Columns. could anyone provide VBA code for this. Thanks! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Extracting data from Website

Any link is ok. Just I need to learn how to do this task. Thanks. On Thu, Jul 21, 2011 at 2:15 PM, ashish koul koul.ash...@gmail.com wrote: can you send the direct link On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, How to extract data from

Re: $$Excel-Macros$$ Extracting data from Website

-of-webpage-to-excel-using.html http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Any link is ok. Just I need to learn how to do this task. Thanks. On Thu, Jul 21, 2011 at 2:15 PM, ashish

Re: $$Excel-Macros$$ Extracting data from Website

Hi Asish, How to pull out particular lines or paragraphs in any site. Can we do this without using webquery method. Please let me know about this. Thanks, Chandra Shekar B On Fri, Jul 22, 2011 at 1:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Thank u Ashish. I will check it out

Fwd: $$Excel-Macros$$ Extracting data from Website

Hi Ashish, Any solution for this. Thanks in advance. -- Forwarded message -- From: Chandra Shekar chandrashekarb@gmail.com Date: Fri, Jul 22, 2011 at 1:21 PM Subject: Re: $$Excel-Macros$$ Extracting data from Website To: excel-macros@googlegroups.com Hi Asish, How to pull

Re: $$Excel-Macros$$ Extracting data from Website

Hi, In the below link I need to extract data by name i.e.*Chandra Shekar *in comments columns. Thank you in advance. http://chandoo.org/wp/2010/01/27/pivot-table-tricks/ On Thu, Jul 28, 2011 at 8:32 AM, ashish koul koul.ash...@gmail.com wrote: can you send me link and text you want to extract

$$Excel-Macros$$ Dynamic Chart

Hi, Can u pls help me in doing dynamic chart in attached file. I tried using formulas which is in attacthed file. But I could not able to do the same. I need only 12 weeks data in the chart. Thanks -- -- Some

Re: $$Excel-Macros$$ Remove HyperLink without Macro

Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C*. Please can u explain briefly regarding this. Thanks! On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance samde...@gmail.com wrote: Nice one XLS S On Jul 31, 10:41 am, XLS S

Re: $$Excel-Macros$$ Dynamic Chart

* * * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Friday, July 29, 2011 7:29 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Dynamic Chart ** ** Hi, Can u pls help me in doing dynamic chart

Re: $$Excel-Macros$$ Remove HyperLink without Macro

format suggested. Share little more details for this it will be very helpful. Thanks! On Mon, Aug 1, 2011 at 3:27 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C

$$Excel-Macros$$ Viritual Memory

Hi, I am using Office 2010 when I try to copy large data I am getting virtual memeory error. May I know how to increase viritual memory in the system. Regards, Chandra Shekar B -- -- Some important links

Re: $$Excel-Macros$$ Viritual Memory

Hi Venkat, I use 3 GB Ram than also I have this kind of problems. Is there any way to resolve this issue. Thanks! On Tue, Aug 2, 2011 at 11:43 AM, Venkat CV venkat1@gmail.com wrote: Hi Chandra Shekar, You may increase system RAM it may increase your virtual memory.. For huge data

Re: $$Excel-Macros$$ Viritual Memory

, Aug 2, 2011 at 12:45 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I am using Office 2010 when I try to copy large data I am getting virtual memeory error. May I know how to increase viritual memory in the system. Regards, Chandra Shekar B

Re: $$Excel-Macros$$ Dynamic Chart

** ** *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* Chandra Shekar *Envoyé :* lundi 1 août 2011 12:02 *À :* excel-macros@googlegroups.com *Objet :* Re: $$Excel-Macros$$ Dynamic Chart ** ** Hi, I needed data for 12 weeks

Re: $$Excel-Macros$$ Dynamic Chart

Hi Haseeb, Thank you very much its working fine. Thanks, Chandra Shekar B On Tue, Aug 2, 2011 at 7:53 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello Chandru, See the attached. If doesn't have 12 entries it will adjust to available entries. If do have more than 12 week

Re: $$Excel-Macros$$ Email : Paste Object

://www.rondebruin.nl/notes.htm On Mon, Aug 8, 2011 at 3:23 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Please find attached file I have code to send mail to lotus notes id. Here I need range from A1:E6 pasted as object as in the body of notes as shown in attached file. Please let me

$$Excel-Macros$$ Notes : Help

Hi, In below code some times I could able to send attachments but some times its not taking attachment at all. Please let me know whats is the problem in the below code. Sub sendmail() ' Dim UserName As String Dim MailDbName As String Dim Recipient As Variant Dim ccRecipient As String Dim

Re: $$Excel-Macros$$ Email : Paste Object

Hi Ashsih, Any help regarding this. Thank you in advance. On Wed, Aug 10, 2011 at 8:14 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi Ashish, Thanks for the reply. If u don't mind can u pls help me with the code which has in attached excel file, because I am little bit confused

Re: $$Excel-Macros$$ Notes : Help

Thanks Ashish I will check it out. :-) On Fri, Aug 12, 2011 at 4:31 AM, ashish koul koul.ash...@gmail.com wrote: try these On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, In below code some times I could able to send attachments but some times

Re: $$Excel-Macros$$ Notes : Help

Hi Ashsh, I used ur code but getting error in below lines. I think I need to enable some reference. Please let me know about this. *Set Data = New DataObject Data.GetFromClipboard * Thanks, Chandra Shekar B On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar chandrashekarb@gmail.com wrote

Re: $$Excel-Macros$$ Notes : Help

Hello Ashish, I got solution for this issue but I am getting one more error in code as type mismatch *Set rnbody1 = Sheets(Details).UsedRange.Copy rnbody1.Copy * On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi Ashsh, I used ur code but getting error

Re: $$Excel-Macros$$ Notes : Help

Hi Ashish, Could u pls help one this code. Thanks On Fri, Aug 12, 2011 at 12:13 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello Ashish, I got solution for this issue but I am getting one more error in code as type mismatch *Set rnbody1 = Sheets(Details).UsedRange.Copy

Re: $$Excel-Macros$$ Notes : Help

On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello Ashish, I got solution for this issue but I am getting one more error in code as type mismatch *Set rnbody1 = Sheets(Details).UsedRange.Copy rnbody1.Copy * On Fri, Aug 12, 2011 at 9:12 AM

  1   2   3   >