Re: $$Excel-Macros$$ Dates based on working hours
See this sheet as per your requirements. Pl let us know if any error. HTH//Vabs On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ v...@vabs.in wrote: Hi Refer hope this will help. http://chandoo.org/wp/2010/09/10/working-hours-formula/ Thanks On Mon, Jun 24, 2013 at 7:18 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Thanks for your reply its Date open Date Close. Regards, Chandra On Mon, Jun 24, 2013 at 7:10 PM, VBA VABZ v...@vabs.in wrote: HI Can you give more clarity. What date1 date2 means here. Thanks On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I need a formula which calculate dates based on working hours please find attached file. Regards, Chandra -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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)
Re: $$Excel-Macros$$ Help Pivot table gives error when adding to addDataFiled
Thanks, I discovered the error, but ended up using your's macros, thank you very much all. On 7 June 2013 15:27, Bé Trần Văn betnmtdongna...@gmail.com wrote: You try this Code, used for Version. Code: Sub PivotTable_Change() Dim PTCache As PivotCache Dim PT As PivotTable Application.ScreenUpdating = False 'Delete Pivot Sheet SPLIT neu no ton tai On Error Resume Next Application.DisplayAlerts = False Sheets(SPLIT).Select Columns(B:Q).Select Selection.Delete Shift:=xlToLeft On Error GoTo 0 'Get data starting from row 1 sheet Table1 Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:=Sheets(Table1).Range(A1).CurrentRegion.Address) 'SPLIT selected worksheet Sheets(SPLIT).Select 'Sheet SPLIT, creating PivotTable from C3 Set PT = PTCache.CreatePivotTable(TableDestination:=Sheets(SPLIT).Range(C3), TableName:=PivotTable1) With PT ''Set PivotTable ActiveSheet.PivotTables(PivotTable1).AddDataField ActiveSheet.PivotTables( _ PivotTable1).PivotFields(TT), Count of TT, xlCount With ActiveSheet.PivotTables(PivotTable1).PivotFields(ASIN) .Orientation = xlRowField .Position = 1 End With Range(B5).Select With ActiveSheet.PivotTables(PivotTable1).PivotFields(ASIN) .Orientation = xlColumnField .Position = 1 End With Range(B6).Select With ActiveSheet.PivotTables(PivotTable1).PivotFields(FC) .Orientation = xlRowField .Position = 1 End With End With End Sub 2013/6/7 Jorge Marques leote.w...@gmail.com Hi guys, I don't know why but I have this recorded macro, that always gives me an error when is putting the field QTY - Quantity in the Values field? Can you help me? Private Sub splitf() Application.ScreenUpdating = False Range(A1).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Application.CutCopyMode = False ActiveSheet.ListObjects.Add(xlSrcRange, Range($A$1:$F$1000), , xlYes).Name = _ Table1 Range(Table1[#All]).Select ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ Table1, Version:=xlPivotTableVersion14).CreatePivotTable TableDestination _ :=SPLIT!R2C1, TableName:=PivotTable1, DefaultVersion:= _ xlPivotTableVersion14 Sheets(SPLIT).Select Cells(2, 1).Select ActiveSheet.PivotTables(PivotTable1).AddDataField ActiveSheet.PivotTables( _ PivotTable1).PivotFields(QTY), Count of QTY, xlCount With ActiveSheet.PivotTables(PivotTable1).PivotFields(Count of QTY) .Caption = Sum of QTY .Function = xlSum End With With ActiveSheet.PivotTables(PivotTable1).PivotFields(ASIN) .Orientation = xlRowField .Position = 1 End With With ActiveSheet.PivotTables(PivotTable1).PivotFields(FC) .Orientation = xlColumnField .Position = 1 End With With ActiveSheet.PivotTables(PivotTable1) .ColumnGrand = False .RowGrand = False End With -- Best Regards, Jorge Marques -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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
Re: $$Excel-Macros$$ get data range used by chart in excel using vba
HI Pl refer: http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx Using the ChartArea Object Use the *ChartArea* property to return the *ChartArea* object. The following example sets the pattern for the chart area in embedded chart one on the worksheet named Sheet1. Worksheets(sheet1).ChartObjects(1).Chart. _ ChartArea.Interior.Pattern = xlLightDown Thanks On Tue, Jun 25, 2013 at 6:00 PM, Divaker Pandey divake...@gmail.com wrote: hi expert how i can get data range used by chart in excel using vba. Divaker -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ get data range used by chart in excel using vba
thanks for your quick response. but i couldn't get, please vabz tell me exact way, how can i get data range used by chart. Thanks On Tue, Jun 25, 2013 at 6:08 PM, VBA VABZ v...@vabs.in wrote: HI Pl refer: http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx Using the ChartArea Object Use the *ChartArea* property to return the *ChartArea* object. The following example sets the pattern for the chart area in embedded chart one on the worksheet named Sheet1. Worksheets(sheet1).ChartObjects(1).Chart. _ ChartArea.Interior.Pattern = xlLightDown Thanks On Tue, Jun 25, 2013 at 6:00 PM, Divaker Pandey divake...@gmail.comwrote: hi expert how i can get data range used by chart in excel using vba. Divaker -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Help in linking data based on PO criteria
Thank you both for the help! Im not very familiar with PFA files or relay code so I will do some research. Any tips on where to look or any website tutorials would be great. Thanks again! On Tuesday, June 25, 2013 2:34:38 AM UTC-4, Ravinder Negi wrote: PFA --- On *Mon, 6/24/13, ryan.w...@gmail.com javascript: ryan.w...@gmail.com javascript:* wrote: From: ryan.w...@gmail.com javascript: ryan.w...@gmail.com javascript: Subject: $$Excel-Macros$$ Help in linking data based on PO criteria To: excel-...@googlegroups.com javascript: Date: Monday, June 24, 2013, 7:41 PM Hi All! My name is Ryan. I am pretty experienced in Excel but have run into a dead in with my recent project. I currently manage all PO's for my company to perform financial formulas, analysis,etc. I had been using a basic filter, however we just expanded and now I am dealing with over 50,000 Po's, which obviously takes a huge amount of my time now. My Goal: I currently use an Excel spreadsheet to log all PO's. All information is gathered, entered into a master spreadsheet (with the exception of the PO nuber), and the PO is assigned the corresponding number. What I would like to do is to design a Macro/V-LookUp/Etc that will read the information entered, and copy that information correctly to a seperate spreadsheet based on my specified criteria automatically. I have attached a very basic workbook that might better illustrate my goal. As you can see, all information is entered and saved on the first sheet (Master PO Log). Based on the Dept # (Column D), I would like to design a formula so that all information for the PO entered will also appear on the corresponding tab. I have color coded them for your convenience and to show which information I would need copied, however the actual PO log will rely off of the Dept # only. Basically, any PO I enter into the log will appear in 2 places, the master PO log and the corresponding Dept Tab automatically, with me only entering the infrmation once. My secondary goal would be to have the Dept tab sorted by name, however, since I don't know how many PO's a certain employee will use in the fiscal year, I would like to to expand accordingly. Again, that is a secondary objective and would be more than happy if I could just accomplish the link. Hope that made sense, Thanks for the help! -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Help in linking data based on PO criteria
Hi Vabz Nur, I have done some research on both PFA's and Relay code and am a little confused at how they can be used in my project? Could either of you expand on how I could use them or refer me to a tutorial or site that will help me get a better understanding so I can apply it to the project? Thanks again! On Tuesday, June 25, 2013 2:34:38 AM UTC-4, Ravinder Negi wrote: PFA --- On *Mon, 6/24/13, ryan.w...@gmail.com javascript: ryan.w...@gmail.com javascript:* wrote: From: ryan.w...@gmail.com javascript: ryan.w...@gmail.com javascript: Subject: $$Excel-Macros$$ Help in linking data based on PO criteria To: excel-...@googlegroups.com javascript: Date: Monday, June 24, 2013, 7:41 PM Hi All! My name is Ryan. I am pretty experienced in Excel but have run into a dead in with my recent project. I currently manage all PO's for my company to perform financial formulas, analysis,etc. I had been using a basic filter, however we just expanded and now I am dealing with over 50,000 Po's, which obviously takes a huge amount of my time now. My Goal: I currently use an Excel spreadsheet to log all PO's. All information is gathered, entered into a master spreadsheet (with the exception of the PO nuber), and the PO is assigned the corresponding number. What I would like to do is to design a Macro/V-LookUp/Etc that will read the information entered, and copy that information correctly to a seperate spreadsheet based on my specified criteria automatically. I have attached a very basic workbook that might better illustrate my goal. As you can see, all information is entered and saved on the first sheet (Master PO Log). Based on the Dept # (Column D), I would like to design a formula so that all information for the PO entered will also appear on the corresponding tab. I have color coded them for your convenience and to show which information I would need copied, however the actual PO log will rely off of the Dept # only. Basically, any PO I enter into the log will appear in 2 places, the master PO log and the corresponding Dept Tab automatically, with me only entering the infrmation once. My secondary goal would be to have the Dept tab sorted by name, however, since I don't know how many PO's a certain employee will use in the fiscal year, I would like to to expand accordingly. Again, that is a secondary objective and would be more than happy if I could just accomplish the link. Hope that made sense, Thanks for the help! -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros.
Re: $$Excel-Macros$$ get data range used by chart in excel using vba
Hi Pl refer this wonderful resource http://www.ozgrid.com/forum/showthread.php?t=161559 Let us know if any help needed. Thanks On Tue, Jun 25, 2013 at 6:58 PM, Divaker Pandey divake...@gmail.com wrote: Hi Group , i have added the file, there is a screen shot of chart data range dialog box, i want that range programmatically. Divaker On Tue, Jun 25, 2013 at 6:19 PM, Divaker Pandey divake...@gmail.comwrote: thanks for your quick response. but i couldn't get, please vabz tell me exact way, how can i get data range used by chart. Thanks On Tue, Jun 25, 2013 at 6:08 PM, VBA VABZ v...@vabs.in wrote: HI Pl refer: http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx Using the ChartArea Object Use the *ChartArea* property to return the *ChartArea* object. The following example sets the pattern for the chart area in embedded chart one on the worksheet named Sheet1. Worksheets(sheet1).ChartObjects(1).Chart. _ ChartArea.Interior.Pattern = xlLightDown Thanks On Tue, Jun 25, 2013 at 6:00 PM, Divaker Pandey divake...@gmail.comwrote: hi expert how i can get data range used by chart in excel using vba. Divaker -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you
$$Excel-Macros$$ Excel Macro to import specific data from PDF to Excel
Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the project,I have very limited VBA knowledge. Thanks Regards, Hamood -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Formula to span number of nights (from Arrival Date to Departure Date) in relevant monthly Column
Thank you De Premor! Works beautifully! -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel
Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the project,I have very limited VBA knowledge. Thanks Regards, Hamood -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Charts
Hi, Is there a way to make default font for charts we prepare in excel every time. At present it is Calibri, I want to change it Century Gothic style for all the new charts I create. Regards, Krishnaraddi V Madolli. CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Excel Macro to import specific data from PDF to Excel
Basole ricardo...@gmail.com wrote: Hamood, post your PDF file and tell what data you want to import Em terça-feira, 25 de junho de 2013 13h36min05s UTC-3, ha...@mst.edu escreveu: Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the project,I have very limited VBA knowledge. Thanks Regards, Hamood -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.