Re: $$Excel-Macros$$ Password protect hidden sheets
Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ excell to pdf
Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ reqment of greater than formula
Hello friends, I want to a formula of gareter than. any body tell me. Anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ reqment of greater than formula
Dear Anil, Please explain, we are not getting your point, On Tue, Jan 31, 2012 at 4:05 PM, anil kumar kmr7a...@gmail.com wrote: Hello friends, I want to a formula of gareter than. any body tell me. Anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ reqment of greater than formula
Hello sir, Thanks for response, I attach file. anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ reqment of greater than formula
Dear Anil, You can use..simple =MAX(D2:G2) or =LARGE(D2:G2,1) See attached sheet.. On Tue, Jan 31, 2012 at 4:24 PM, anil kumar kmr7a...@gmail.com wrote: Hello sir, Thanks for response, I attach file. anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1(Anil).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ reqment of greater than formula
sorry sir, but i want to know what is use of 1 in large formula. and my second queary can solve anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ reqment of greater than formula
Dear Anil, In large function 1 is using for rank See details about large function.. MS Excel: Large Function -- In Excel, the *Large* function returns the nth largest value from a set of values. The syntax for the *Large* function is: Large( array, nth_position ) *array* is a range or array from which you want to return the nth largest value. *nth_position* is the position from the largest to return. Applies To: - Excel 2007, Excel 2003, Excel XP, Excel 2000 Note: If *nth_position* is larger than the number of values in *array*, the Large function will return the #NUM! error. If *array* is empty, the Large function will return the #NUM! error. For example: Let's take a look at an example: Based on the Excel spreadsheet above: =Large(A1:A5, 1) would return 32 =Large(A1:A5, 2) would return 8 =Large(A1:A5, 3) would return 5.7 =Large(A1:A5, 4) would return 4 =Large(A1:A5, 5) would return -2.3 =Large({6, 23, 5, 2.3}, 2) would return 6 On Tue, Jan 31, 2012 at 5:19 PM, anil kumar kmr7a...@gmail.com wrote: sorry sir, but i want to know what is use of 1 in large formula. and my second queary can solve anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ reqment of greater than formula
Thanks sir, I will follow this formula than i give u msg Thanks again Anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Query continuous copy paste
Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Xl008.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ excell to pdf
Try this: Sub CreatePDF() Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Jan/Tue/2012 03:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ excell to pdf Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Query continuous copy paste
Try this : Sub Transformdata() Dim rngCEll As Range Dim rngRange As Range Dim wksOutput As Worksheet Set wksOutput = ThisWorkbook.Worksheets.Add Set rngRange = ThisWorkbook.Worksheets(Query).Rows(1) For Each rngCEll In rngRange.Cells Application.ScreenUpdating = False If rngCEll.Value = Then Exit For If rngCEll.Value = Name Then rngCEll.Resize(rngCEll.End(xlDown).Row, 2).Copy wksOutput.Range(A WorksheetFunction.CountA(wksOutput.Range(A:A)) + 1) End If Next With wksOutput .UsedRange.WrapText = False .Rows.AutoFit .Columns.AutoFit .Range($A$1:$B$114).AutoFilter Field:=1, Criteria1:=Name .Cells.SpecialCells(xlCellTypeVisible).EntireRow.Delete .Range(A1).EntireRow.Insert .Range(A1).Value = Name .Range(B1).Value = No End With Application.ScreenUpdating = False End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Kumar Sent: Jan/Tue/2012 01:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query continuous copy paste Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ excell to pdf
hi Rajan, lot of thanks it is working fine Regards chandru On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Sub CreatePDF() ** ** Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Next End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran *Sent:* Jan/Tue/2012 03:37 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ excell to pdf ** ** Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Password protect hidden sheets
Hi After hiding worksheet.. paste this in worksheet code module Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect YourPassWord .Visible = xlSheetHidden StrPass = InputBox(kindly enter password to unprotect sheet) If StrPass = YourPassWord Then .Unprotect YourPassWord .Visible = True Else MsgBox Incorrect Password,Woksheet can not be visible, vbCritical, Password Required End If End With End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Tue/2012 01:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Password protect hidden sheets Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide I have excel 2007 version If any more details req kindly let me know Regards Priyanka -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ reqment of greater than formula
Try with CSE =LARGE(SUMPRODUCT(--(NOT(ISERROR(E5:X5)))*IFERROR(E5:$X$5,0)),1) Rajann. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Tue/2012 05:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ reqment of greater than formula sir, max is work but large is not work. sir i attahe a file in which i have to remove error. i hope u guide me anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
FW: $$Excel-Macros$$ reqment of greater than formula
Please ignore previous Try this With CSE =LARGE(--(NOT(ISERROR(E3:W3)))*IFERROR(E3:W3,0),1) Rajan From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Jan/Tue/2012 07:07 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ reqment of greater than formula Try with CSE =LARGE(SUMPRODUCT(--(NOT(ISERROR(E5:X5)))*IFERROR(E5:$X$5,0)),1) Rajann. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Tue/2012 05:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ reqment of greater than formula sir, max is work but large is not work. sir i attahe a file in which i have to remove error. i hope u guide me anil -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ excell to pdf
Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Minimum Maximum value of a Cell
Why would you even need such a large UDF. This should do it. Function MAXVAL(strTEXT As String) As Long Dim lngLoop As Long For lngLoop = 1 To Len(strTEXT) MAXVAL = Application.Max(1 * IIf(IsNumeric(Mid(strTEXT, lngLoop, 1)), Mid(strTEXT, lngLoop, 1), 0), MAXVAL) Next lngLoop End Function Function MINVAL(strTEXT As String) As Long Dim lngLoop As Long MINVAL = 9 For lngLoop = 1 To Len(strTEXT) MINVAL = Application.Min(1 * IIf(IsNumeric(Mid(strTEXT, lngLoop, 1)), Mid(strTEXT, lngLoop, 1), 0), MINVAL) Next lngLoop End Function If you need a formula, =MAX(--MID(A2,ROW(INDIRECT(1:LEN(A2))),1)) as CSE, similar to Rajan's, will also work. Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 12:09 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Pravesh, Try it..UDF *For Minimum Value..*. Function Minval(x As String) Dim i As Integer, minx As Integer For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then minx = Mid(x, i, 1) Exit For End If Next For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then If Mid(x, i, 1) minx Then minx = Mid(x, i, 1) End If End If Next i Minval = minx End Function *For Maximum Value* Function Maxval(x As String) Dim i As Integer, maxx As Integer For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then maxx = Mid(x, i, 1) Exit For End If Next For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then If Mid(x, i, 1) maxx Then maxx = Mid(x, i, 1) End If End If Next i Maxval = maxx End Function See attached sheet -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Jan 31, 2012 at 9:42 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi Group, I need to extract min max value of a cell. Sample sheet is attached herewith. Thanks in advance. With Regards, Pravesh -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Sent Mailer data
See if it helps: Sub SendMail() Application.Dialogs(xlDialogSendMail).Show End sub Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anjul Porwal Sent: Jan/Tue/2012 12:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sent Mailer data hi. attach data for mailer. we want macro for sent data for anil. Regards Anjul. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ excell to pdf
hi, its not working to me also, error in line fixed width is comming with regards raghu On Tue, Jan 31, 2012 at 7:13 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ excell to pdf
Which version of excel are u using?? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of raghu gr Sent: Jan/Tue/2012 07:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf hi, its not working to me also, error in line fixed width is comming with regards raghu On Tue, Jan 31, 2012 at 7:13 PM, KAUSHIK SAVLA savla.kaus...@gmail.com wrote: Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ excell to pdf
Hi Rajan, I am using excel 2007 version. Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells
May I ask why you did not like my solution? Sub TTC_SAS() Application.ScreenUpdating = False Application.DisplayAlerts = False Columns(g:o).Delete Columns(A).TextToColumns Destination:=Range(G1), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(4, 1)), TrailingMinusNumbers:=True Columns(C).TextToColumns Destination:=Range(I1), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 3), Array(9, 1)), TrailingMinusNumbers:=True Columns(D).TextToColumns Destination:=Range(J1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:=- Columns(E).TextToColumns Destination:=Range(N1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:=X Application.DisplayAlerts = True Columns(f).Copy Range(p1) Columns.AutoFit Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Tuesday, January 31, 2012 2:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells Dear group, 1. Based on the ideas from Paul, changing code can help me to get desired results. If IsEmpty(.Cells(R, E)) Then .Cells(R, N).Value = .Cells(R, O).Value = ElseIf (InStr(.Cells(R, E).Value, X) 0) Then .Cells(R, N).Value = Left(.Cells(R, E).Value, (InStr(.Cells(R, E).Value, X) - 1)) .Cells(R, O).Value = Mid(.Cells(R, E).Value, (InStr(.Cells(R, E).Value, X) + 1), 3) Else .Cells(R, N).Value = .Cells(R, E).Value .Cells(R, O).Value = End If .Cells(R, P).Value = Cells(R, F).Value Next R 2. A However, as users have changed their mind, so I have to change the code for other parts. For step 2 in my code, the sztyhg (Column B in file) can determine other values in the file. Company code go to HHKHKGHKHKGRTT with third digit of sztyhg =G go to HHKHKGHKHKGRT1 with third digit of sztyhg =R Remark same data as sztyhg Man Rate O go to 40 with third digit of sztyhg =G go to 48 with third digit of sztyhg =R 2.B But some other changes happened when I use original method to get damage code and repair code, it does not get the desired results as I want, could anyone help to find out what is the problem? 2012/1/31 Rajan_Verma rajanverma1...@gmail.com You can use Split method and Assign split values to range Range(“A1:C1”)=split(“A:B:C”,”:”) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Jan/Mon/2012 08:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells oops. change o1 to p1 Application.DisplayAlerts = True Columns(f).Copy Range(p1) Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Sunday, January 29, 2012 11:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells Dear group, I would like to get the value from 1 cell and split the value to 2 cells. Any VBA formula can help achieve this? Code starts from Private Sub CommandButton2_Click() Criteria: Depends on the position of X. If no value in original cell, just leave it blank. The value before X is length, the value after X is width. Attached can find sample for reference. -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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.
RE: $$Excel-Macros$$ excell to pdf
Ok.. it will give error if your worksheet does not have any data Try this Sub CreatePDF() Dim wksSheet As Worksheet Dim intI As Integer intI = 0 For Each wksSheet In ThisWorkbook.Worksheets If WorksheetFunction.CountA(wksSheet.Cells) 0 Then wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False intI = intI + 1 End If Next MsgBox intI Worksheet(s) has been Exported to PDF, vbInformation End Sub Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Jan/Tue/2012 07:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf Hi Rajan, I am using excel 2007 version. Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Formula Hide in Excel Work Sheet.
Hi Group, How to Hide formula in excel work sheet. Please suggest. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ pdf to word document
Dear sir, how to convert pdf file to text file... On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Sub CreatePDF() ** ** Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Next End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran *Sent:* Jan/Tue/2012 03:37 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ excell to pdf ** ** Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula Hide in Excel Work Sheet.
Dear Bhupender, Select formula area and press ctrl+1 and goto protection and selec Hidden and protect sheet See atthached Screen Shot.. On Tue, Jan 31, 2012 at 7:51 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: Hi Group, How to Hide formula in excel work sheet. Please suggest. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$
I suggest you NOT do that. Instead delete the blanks and use datafilterautofilterfilter as desired. Don Guillett SalesAid Software dguille...@gmail.com From: raghu gr Sent: Tuesday, January 31, 2012 8:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi, In customer data base i want to copy each customer details in each page. mean to say - i want Ramu details in Page2 (3 rows), Bhaskar details in page3, Shannu details in page 4 and so on. how to do this using vba, pls help regarding this Attached sample file, Thank you Balaji -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ pdf to word document
Dear Veeru, You can download free pdf to text converter through below link.. http://www.pdf-to-html-word.com/pdf-to-text/ On Tue, Jan 31, 2012 at 7:47 PM, Veeru TOC veerub...@gmail.com wrote: Dear sir, how to convert pdf file to text file... On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Sub CreatePDF() ** ** Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Next End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran *Sent:* Jan/Tue/2012 03:37 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ excell to pdf ** ** Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook.
RE: $$Excel-Macros$$ pdf to word document
Hi You can Open PDF File in adobe Reader and save as Text file, I think you may lost data formatting ,to avoid this you need to buy any program as noorain suggested.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Tue/2012 08:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ pdf to word document Dear Veeru, You can download free pdf to text converter through below link.. http://www.pdf-to-html-word.com/pdf-to-text/ On Tue, Jan 31, 2012 at 7:47 PM, Veeru TOC veerub...@gmail.com wrote: Dear sir, how to convert pdf file to text file... On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Try this: Sub CreatePDF() Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Jan/Tue/2012 03:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ excell to pdf Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ThanksRegards Veerendra.Vanam TOC TEAM Bhagyanagar Electrical Contractors H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh 91-9177-444-840, -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ -- 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 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
$$Excel-Macros$$ Excel Symbol.
Hi Group, I Need a spacial Symbol insert to excel work sheet. there is any opetion. Please suggest. Regards Raghav. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ excell to pdf
Dear Kaushik You have a hidden worksheet in this workbook Replace this code . . . . For Each wksSheet In ThisWorkbook.Worksheets If WorksheetFunction.CountA(wksSheet.Cells) 0 Then If wksSheet.Visible = xlSheetHidden Then wksSheet.Visible = xlSheetVisible wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=True, OpenAfterPublish:= _ False intI = intI + 1 End If Next From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Jan/Tue/2012 08:10 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf Hi Rajan, Please find attached file I am using. Password for opening file is sjc123 Please suggest. Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Activate The fill Handle
Hi Group, How to activate the fill handle. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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,
RE: $$Excel-Macros$$ Excel Symbol.
Goto Insert-Symbol You can insert any symbol from here Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:18 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Symbol. Hi Group, I Need a spacial Symbol insert to excel work sheet. there is any opetion. Please suggest. Regards Raghav. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ excell to pdf
Hi Rajan, Problem resolved. Excellent job to help us on this article. Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Activate The fill Handle
HI Raghav, See the attached Link http://www.excelvbamacros.com/search/label/Activate%20The%20fill%20Handle Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:21 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Activate The fill Handle Hi Group, How to activate the fill handle. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Excel Symbol.
Insert Symbol Select the one you want. If not found change the font from drop down. Prakash On Jan 31, 7:47 pm, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: Hi Group, I Need a spacial Symbol insert to excel work sheet. there is any opetion. Please suggest. Regards Raghav. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Activate The fill Handle
Dear Raghav, http://support.microsoft.com/kb/291359 you can search in google more explain On Tue, Jan 31, 2012 at 8:21 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: Hi Group, How to activate the fill handle. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel Symbol.
Rajan Sir, There is limited symbol collection I would like to insert a specific symbol which is designed by me that is not in excel default symbol. How I can insert this?? On Tue, Jan 31, 2012 at 8:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Goto Insert-Symbol You can insert any symbol from here ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *bhupendra singh raghav *Sent:* Jan/Tue/2012 08:18 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Excel Symbol. ** ** Hi Group, I Need a spacial Symbol insert to excel work sheet. there is any opetion. Please suggest. Regards Raghav. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Activate The fill Handle
Dear Sir, There is some screen shot I am unable to understand please provide on mail. On Tue, Jan 31, 2012 at 8:28 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Raghav, See the attached Link ** ** http://www.excelvbamacros.com/search/label/Activate%20The%20fill%20Handle* *** ** ** Rajan ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *bhupendra singh raghav *Sent:* Jan/Tue/2012 08:21 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Activate The fill Handle ** ** Hi Group, How to activate the fill handle. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ excell to pdf
See the final Version Sub CreatePDF() Dim wksSheet As Worksheet Dim blnFlag As Boolean Dim intI As Integer Dim intResult As Byte intI = 0 intResult = Application.InputBox(Type 1 for Entire Workbook and Type 0 For Active Worksheets) If intResult = 0 Then Set wksSheet = ActiveSheet wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Exit Sub End If For Each wksSheet In ThisWorkbook.Worksheets If WorksheetFunction.CountA(wksSheet.Cells) 0 Then If wksSheet.Visible = xlSheetHidden Then wksSheet.Visible = xlSheetVisible blnFlag = True End If wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False intI = intI + 1 If blnFlag = True Then wksSheet.Visible = xlSheetHidden blnFlag = False End If End If Next MsgBox intI Worksheet(s) has been Exported to PDF, vbInformation End Sub Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Jan/Tue/2012 08:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excell to pdf Hi Rajan, Problem resolved. Excellent job to help us on this article. Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Try Option Explicit Sub copycolumstorowsSAS() Dim i As Long For i = 1 To Cells(1, Columns.Count).End(xlToLeft).Column Step 2 Cells(2, i).Resize(6, 2).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1) Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Mukesh Kumar Sent: Tuesday, January 31, 2012 1:40 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query continuous copy paste Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Excel Symbol.
You can go to this link http://www.ozgrid.com/forum/showthread.php?t=94991 Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:31 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Symbol. Rajan Sir, There is limited symbol collection I would like to insert a specific symbol which is designed by me that is not in excel default symbol. How I can insert this?? On Tue, Jan 31, 2012 at 8:27 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Goto Insert-Symbol You can insert any symbol from here Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Jan/Tue/2012 08:18 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Symbol. Hi Group, I Need a spacial Symbol insert to excel work sheet. there is any opetion. Please suggest. Regards Raghav. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ How to View formula....
Hi Group, I am working on A official report so frequently I need your help. Thank for your corporation. I have a data having 700 columns but I am unable to identify where formula exist is there any way to identify to seen. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to View formula....
Goto Formula-Show Formula On Tue, Jan 31, 2012 at 9:00 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: Hi Group, I am working on A official report so frequently I need your help. Thank for your corporation. I have a data having 700 columns but I am unable to identify where formula exist is there any way to identify to seen. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ How to View formula....
Press CTRL+~ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Tue/2012 09:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to View formula Goto Formula-Show Formula On Tue, Jan 31, 2012 at 9:00 PM, bhupendra singh raghav raghav.bhupen...@gmail.com wrote: Hi Group, I am working on A official report so frequently I need your help. Thank for your corporation. I have a data having 700 columns but I am unable to identify where formula exist is there any way to identify to seen. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
@ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use
Re: $$Excel-Macros$$ Query continuous copy paste
Always nice to tell us the ENTIRE problem at the FIRST post. It appears that, if you give proper info, then the last offering by Noorain should work. Don Guillett SalesAid Software dguille...@gmail.com From: Mukesh Kumar Sent: Tuesday, January 31, 2012 9:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query continuous copy paste @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
RE: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells
Hi Do you want this? , see the attached =TRANSPOSE(MID(A1,ROW(INDIRECT(1: LEN(A1))),1)) as CSE Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Jan/Tue/2012 07:40 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells May I ask why you did not like my solution? Sub TTC_SAS() Application.ScreenUpdating = False Application.DisplayAlerts = False Columns(g:o).Delete Columns(A).TextToColumns Destination:=Range(G1), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(4, 1)), TrailingMinusNumbers:=True Columns(C).TextToColumns Destination:=Range(I1), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 3), Array(9, 1)), TrailingMinusNumbers:=True Columns(D).TextToColumns Destination:=Range(J1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:=- Columns(E).TextToColumns Destination:=Range(N1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar:=X Application.DisplayAlerts = True Columns(f).Copy Range(p1) Columns.AutoFit Application.ScreenUpdating = True End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan mailto:darwin.chankaw...@gmail.com Sent: Tuesday, January 31, 2012 2:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells Dear group, 1. Based on the ideas from Paul, changing code can help me to get desired results. If IsEmpty(.Cells(R, E)) Then .Cells(R, N).Value = .Cells(R, O).Value = ElseIf (InStr(.Cells(R, E).Value, X) 0) Then .Cells(R, N).Value = Left(.Cells(R, E).Value, (InStr(.Cells(R, E).Value, X) - 1)) .Cells(R, O).Value = Mid(.Cells(R, E).Value, (InStr(.Cells(R, E).Value, X) + 1), 3) Else .Cells(R, N).Value = .Cells(R, E).Value .Cells(R, O).Value = End If .Cells(R, P).Value = Cells(R, F).Value Next R 2. A However, as users have changed their mind, so I have to change the code for other parts. For step 2 in my code, the sztyhg (Column B in file) can determine other values in the file. Company code go to HHKHKGHKHKGRTT with third digit of sztyhg =G go to HHKHKGHKHKGRT1 with third digit of sztyhg =R Remark same data as sztyhg Man Rate O go to 40 with third digit of sztyhg =G go to 48 with third digit of sztyhg =R 2.B But some other changes happened when I use original method to get damage code and repair code, it does not get the desired results as I want, could anyone help to find out what is the problem? 2012/1/31 Rajan_Verma rajanverma1...@gmail.com You can use Split method and Assign split values to range Range(A1:C1)=split(A:B:C,:) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Jan/Mon/2012 08:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells oops. change o1 to p1 Application.DisplayAlerts = True Columns(f).Copy Range(p1) Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan mailto:darwin.chankaw...@gmail.com Sent: Sunday, January 29, 2012 11:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells Dear group, I would like to get the value from 1 cell and split the value to 2 cells. Any VBA formula can help achieve this? Code starts from Private Sub CommandButton2_Click() Criteria: Depends on the position of X. If no value in original cell, just leave it blank. The value before X is length, the value after X is width. Attached can find sample for reference. -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread
$$Excel-Macros$$ based on worksheet attached pdf sent email
Dear all Based on my Worksheets i already having pdf file which i attached and sent respective email address i have email address each sheets K7 How do i attached particular pdf and sent their email id Here is code what i have wrong Sub Send_Email_Current_Workbook() Dim OutApp As Object Dim OutMail As Object Dim wksSheet As Worksheet Set OutApp = CreateObject(Outlook.Application) OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next For Each wksSheet In ThisWorkbook.Worksheets With OutMail .To = wksSheet.Range(k7).Value .Subject = Salary Slip .Body = Salary Slip for the month of ActiveSheet.Range(M4).Value .Attachments.Add ThisWorkbook.Path \ wksSheet.Name .pdf ssfile = ThisWorkbook.Path \ wksSheet.Name .pdf .Send End With Next On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Sub Consolidator() Dim rngSource As Range Dim lngCols As Long, lngRows As Long Set rngSource = Range(A1).CurrentRegion lngRows = rngSource.CurrentRegion.Rows.Count - 1 For lngCols = 3 To rngSource.Columns.Count - 1 Step 2 rngSource.Cells(2, lngCols).Resize(lngRows, 2).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next lngCols rngSource.Offset(, 2).Delete xlUp End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:10 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Here's the working model. Have given a button for ease. Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:21 PM, Sam Mathai Chacko samde...@gmail.comwrote: Sub Consolidator() Dim rngSource As Range Dim lngCols As Long, lngRows As Long Set rngSource = Range(A1).CurrentRegion lngRows = rngSource.CurrentRegion.Rows.Count - 1 For lngCols = 3 To rngSource.Columns.Count - 1 Step 2 rngSource.Cells(2, lngCols).Resize(lngRows, 2).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next lngCols rngSource.Offset(, 2).Delete xlUp End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:10 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
One of the header is 'No' instead of 'No.' Correct the headers, it should work Kris -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Solve problem,Plz help me
Dear group, Plz help me ... On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below type but i required this type of data Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 Req data: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ HOW TO OPEN PASSWORD PROTECTED FILE
Hi Experts, i was trying to learn how this dasboard was made, but seems sheet 2 which links to the dashboard sheet is password protected, can anyone crack it for me, thanks -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ pdf to word document
Thank you.. On Tue, Jan 31, 2012 at 8:01 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Veeru, You can download free pdf to text converter through below link.. http://www.pdf-to-html-word.com/pdf-to-text/ On Tue, Jan 31, 2012 at 7:47 PM, Veeru TOC veerub...@gmail.com wrote: Dear sir, how to convert pdf file to text file... On Tue, Jan 31, 2012 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Sub CreatePDF() ** ** Dim wksSheet As Worksheet For Each wksSheet In ThisWorkbook.Worksheets wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Next End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *chandra sekaran *Sent:* Jan/Tue/2012 03:37 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ excell to pdf ** ** Dear all i need macro for excel to pdfi have 25 sheet each sheet convert to pdf . PDF file name should be a Sheet name any one help me Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- 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 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
$$Excel-Macros$$ Solve problem,Plz help me
Dear All, Can i use pivot table up to data came below type but i required this type of data Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 Req data: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ HOW TO OPEN PASSWORD PROTECTED FILE
Dear Hilary, Please read Forum Rules 3) Don't post questions regarding breaking or bypassing any security measure On Tue, Jan 31, 2012 at 8:49 PM, hilary lomotey resp...@gmail.com wrote: Hi Experts, i was trying to learn how this dasboard was made, but seems sheet 2 which links to the dashboard sheet is password protected, can anyone crack it for me, thanks -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Solve problem in excel
Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$
And if you still insist :) Sub Consolidator() Dim col As New Collection Dim lngRow As Long Dim strSheetName As String For lngRow = Sheets.Count To 1 Step -1 Application.DisplayAlerts = 0 If Sheets(lngRow).Name Jan1Rake Then 'ActiveSheet.Name Then Sheets(lngRow).Delete End If Application.DisplayAlerts = 1 Next strSheetName = ActiveSheet.Name For lngRow = 3 To Cells(Rows.Count, 1).End(xlUp).Row If Cells(lngRow, D).Value Then On Error Resume Next col.Add Cells(lngRow, D).Value, Cells(lngRow, D).Value Err.Clear: On Error GoTo 0 End If Next lngRow For lngRow = 1 To col.Count Worksheets(strSheetName).Range(A2:K Worksheets(strSheetName).Cells(Rows.Count, 1).End(xlUp).Row).AutoFilter 4, col.Item(lngRow) With Worksheets.Add(After:=Sheets(Sheets.Count)) .Name = col.Item(lngRow) Worksheets(strSheetName).Range(A2:K Worksheets(strSheetName).Cells(Rows.Count, 1).End(xlUp).Row).Copy .Cells(1) End With Next lngRow Worksheets(strSheetName).AutoFilterMode = 0 End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 7:58 PM, dguillett1 dguille...@gmail.com wrote: I suggest you NOT do that. Instead delete the blanks and use datafilterautofilterfilter as desired. Don Guillett SalesAid Software dguille...@gmail.com *From:* raghu gr balaji.bra...@gmail.com *Sent:* Tuesday, January 31, 2012 8:04 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Hi, In customer data base i want to copy each customer details in each page. mean to say - i want Ramu details in Page2 (3 rows), Bhaskar details in page3, Shannu details in page 4 and so on. how to do this using vba, pls help regarding this Attached sample file, Thank you Balaji -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ RE: Hands on on Excel
Is there no one who is in this group from Indore? This is the first time I've seen a no suggestions-no response situation. Regards, Vani Sharma From: Vani Sharma Sent: Tuesday, 17 January, 2012 7:52 PM To: excel-macros@googlegroups.com Subject: Hands on on Excel All, Looking for hands-on excel training to work large databases in Indore. Please send references about anyone relevant Regards, Vani Sharma Information transmitted by this e-mail is proprietary to MphasiS, its associated companies and/ or its customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmas...@mphasis.com and delete this mail from your records. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ RE: Hands on on Excel
Hi Vani, I know a person which is also member of our Excel macro forum MR.Pankaj Pandey email Id :secrets...@gmail.com provide Advance MS Excel Training. But i m not sure he reside in Indore or Bhopal. Can you touch with him through above mentioned Email ID. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Jan 31, 2012 at 11:06 PM, Vani Sharma vani.sha...@mphasis.comwrote: Is there no one who is in this group from Indore? This is the first time I’ve seen a “no suggestions-no response” situation. ** ** Regards, *Vani Sharma* ** ** *From:* Vani Sharma *Sent:* Tuesday, 17 January, 2012 7:52 PM *To:* excel-macros@googlegroups.com *Subject:* Hands on on Excel ** ** All, ** ** Looking for hands-on excel training to work large databases in Indore. Please send references about anyone relevant ** ** Regards, *Vani Sharma* ** ** Information transmitted by this e-mail is proprietary to MphasiS, its associated companies and/ or its customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmas...@mphasis.com and delete this mail from your records. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Solve problem in excel
Sub Consolidator() Dim rngSource As Range Dim lngCount As Long Dim strArray() As String With Worksheets(Sheet7) Set rngSource = .Range(A4:C .Cells(Rows.Count, 1).End(xlUp)(0).Row) lngCount = Application.CountA(rngSource.Columns(1).Cells) ReDim strArray(lngCount, 1) End With strArray(0, 0) = Indus ID strArray(0, 1) = Text lngCount = Empty For Each rngSource In rngSource.Columns(1).Cells If rngSource.Value Then lngCount = lngCount + 1 strArray(lngCount, 0) = rngSource.Value End If strArray(lngCount, 1) = strArray(lngCount, 1) rngSource.Offset(, 1).Value rngSource.Offset(, 2).Text , Next rngSource Range(E4).Resize(lngCount + 1, 2).Value = strArray End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:42 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ How to View formula....
Hi Bhupendra, .Ctrl-F (Find) .Options - Match Entire Cell Contents, Look in: Formulas .Find What - =* .Find/Find Next/Find All (I think Find All is only in newer versions of Excel). It will also include text cells that begin with an =, if you happen to have any. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bhupendra singh raghav Sent: Tuesday, January 31, 2012 7:30 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to View formula Hi Group, I am working on A official report so frequently I need your help. Thank for your corporation. I have a data having 700 columns but I am unable to identify where formula exist is there any way to identify to seen. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ based on worksheet attached pdf sent email
The code here is very straight forward and simple to use http://www.excelfox.com/forum/f2/excel-template-macro-sending-mails-attahment-thru-outlook-142/ Check the attachment provided also Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 9:47 PM, chandra sekaran duraichan...@gmail.comwrote: Dear all Based on my Worksheets i already having pdf file which i attached and sent respective email address i have email address each sheets K7 How do i attached particular pdf and sent their email id Here is code what i have wrong Sub Send_Email_Current_Workbook() Dim OutApp As Object Dim OutMail As Object Dim wksSheet As Worksheet Set OutApp = CreateObject(Outlook.Application) OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next For Each wksSheet In ThisWorkbook.Worksheets With OutMail .To = wksSheet.Range(k7).Value .Subject = Salary Slip .Body = Salary Slip for the month of ActiveSheet.Range(M4).Value .Attachments.Add ThisWorkbook.Path \ wksSheet.Name .pdf ssfile = ThisWorkbook.Path \ wksSheet.Name .pdf .Send End With Next On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub Regards chandru -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Solve problem in excel
dear sir, can i this pivot tabel after use this vba code but use total vba code and get out put what my requirment data in vba codes On Tue, Jan 31, 2012 at 11:13 PM, Sam Mathai Chacko samde...@gmail.comwrote: Sub Consolidator() Dim rngSource As Range Dim lngCount As Long Dim strArray() As String With Worksheets(Sheet7) Set rngSource = .Range(A4:C .Cells(Rows.Count, 1).End(xlUp)(0).Row) lngCount = Application.CountA(rngSource.Columns(1).Cells) ReDim strArray(lngCount, 1) End With strArray(0, 0) = Indus ID strArray(0, 1) = Text lngCount = Empty For Each rngSource In rngSource.Columns(1).Cells If rngSource.Value Then lngCount = lngCount + 1 strArray(lngCount, 0) = rngSource.Value End If strArray(lngCount, 1) = strArray(lngCount, 1) rngSource.Offset(, 1).Value rngSource.Offset(, 2).Text , Next rngSource Range(E4).Resize(lngCount + 1, 2).Value = strArray End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:42 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra
Re: $$Excel-Macros$$ Solve problem in excel
This works on the Pivot table only If you want a macro to create the pivot table also, that can be done. Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 11:19 PM, Veeru TOC veerub...@gmail.com wrote: dear sir, can i this pivot tabel after use this vba code but use total vba code and get out put what my requirment data in vba codes On Tue, Jan 31, 2012 at 11:13 PM, Sam Mathai Chacko samde...@gmail.comwrote: Sub Consolidator() Dim rngSource As Range Dim lngCount As Long Dim strArray() As String With Worksheets(Sheet7) Set rngSource = .Range(A4:C .Cells(Rows.Count, 1).End(xlUp)(0).Row) lngCount = Application.CountA(rngSource.Columns(1).Cells) ReDim strArray(lngCount, 1) End With strArray(0, 0) = Indus ID strArray(0, 1) = Text lngCount = Empty For Each rngSource In rngSource.Columns(1).Cells If rngSource.Value Then lngCount = lngCount + 1 strArray(lngCount, 0) = rngSource.Value End If strArray(lngCount, 1) = strArray(lngCount, 1) rngSource.Offset(, 1).Value rngSource.Offset(, 2).Text , Next rngSource Range(E4).Resize(lngCount + 1, 2).Value = strArray End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:42 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code for three similar headers another coding is required so on. Can u give common macro irrespective of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command Button On Tue, Jan 31, 2012 at 9:20 PM, Mukesh Kumar mukeshka...@gmail.comwrote: @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 attention or may not be
Re: $$Excel-Macros$$ learn from basic
2012/1/31 Rajan_Verma rajanverma1...@gmail.com You can visit these sites for advance and Basic VBA.. ** ** www.ozgrid.com www.cpearson.com www.akoul.blogspot.com www.excelpoweruser.blogspot.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org www.mvps.org/links.html www.vbaexpress.com www.functionx.com www.freevbcode.com www.excelforum.com https://www.facebook.com/ExcelLover https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897* *** https://www.facebook.com/microsoftexcel https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2ref=ts http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/ http://www.excelvbamacros.com/ http://ashish-msaccess.blogspot.com/ http://www.facebook.com/groups/163491717053198/ http://www.facebook.com/groups/214214011997936/ http://www.facebook.com/pages/Access-VBA-Macros-Codes/212032078844161 http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *satiqjaffar satiqjaffar *Sent:* Jan/Thu/2012 11:29 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ learn from basic ** ** Dear Experts, ** ** I would like to learn the excel VBA from basic. Please let me know source from site. Thanks in advance ** ** Regards Satiq -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Thank NOORAIN Ansari You give me some useful reference address. Thank you very much. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ learn from basic
2012/2/1 Bé Trần Văn betnmtdongna...@gmail.com 2012/1/31 Rajan_Verma rajanverma1...@gmail.com You can visit these sites for advance and Basic VBA.. ** ** www.ozgrid.com www.cpearson.com www.akoul.blogspot.com www.excelpoweruser.blogspot.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org www.mvps.org/links.html www.vbaexpress.com www.functionx.com www.freevbcode.com www.excelforum.com https://www.facebook.com/ExcelLover https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897 https://www.facebook.com/microsoftexcel https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2ref=ts http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/ http://www.excelvbamacros.com/ http://ashish-msaccess.blogspot.com/ http://www.facebook.com/groups/163491717053198/ http://www.facebook.com/groups/214214011997936/ http://www.facebook.com/pages/Access-VBA-Macros-Codes/212032078844161 http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *satiqjaffar satiqjaffar *Sent:* Jan/Thu/2012 11:29 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ learn from basic ** ** Dear Experts, ** ** I would like to learn the excel VBA from basic. Please let me know source from site. Thanks in advance ** ** Regards Satiq -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Thank *NOORAIN **Ansari* and *Rajan_Verma* You give me some useful reference address. Thank you very much. -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Solve problem in excel
Dear Sir, When i click VBA code i am directly enter to my required data in New sheet from raw data On Tue, Jan 31, 2012 at 11:37 PM, Sam Mathai Chacko samde...@gmail.comwrote: This works on the Pivot table only If you want a macro to create the pivot table also, that can be done. Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 11:19 PM, Veeru TOC veerub...@gmail.com wrote: dear sir, can i this pivot tabel after use this vba code but use total vba code and get out put what my requirment data in vba codes On Tue, Jan 31, 2012 at 11:13 PM, Sam Mathai Chacko samde...@gmail.comwrote: Sub Consolidator() Dim rngSource As Range Dim lngCount As Long Dim strArray() As String With Worksheets(Sheet7) Set rngSource = .Range(A4:C .Cells(Rows.Count, 1).End(xlUp)(0).Row) lngCount = Application.CountA(rngSource.Columns(1).Cells) ReDim strArray(lngCount, 1) End With strArray(0, 0) = Indus ID strArray(0, 1) = Text lngCount = Empty For Each rngSource In rngSource.Columns(1).Cells If rngSource.Value Then lngCount = lngCount + 1 strArray(lngCount, 0) = rngSource.Value End If strArray(lngCount, 1) = strArray(lngCount, 1) rngSource.Offset(, 1).Value rngSource.Offset(, 2).Text , Next rngSource Range(E4).Resize(lngCount + 1, 2).Value = strArray End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:42 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 But i need Requirement data type: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks very very much Sam Mathai Chacko sir. This was the resultant code i was looking for. You are marvellous in excel sir. Thanks again. Regards, Mukesh Kumar On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote: The code I gave was exactly for assigning any number of header groups. Sam On Tue, Jan 31, 2012 at 11:44 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code for three similar headers another coding is required so on. Can u give common macro irrespective of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command Button On Tue, Jan 31, 2012 at 9:20 PM, Mukesh Kumar mukeshka...@gmail.comwrote: @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh Kumar -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari
Re: $$Excel-Macros$$ Checkbox disappears when Macro Run
Sorry ..late getting back to say that Don your example worked..thanks for your help on this.. On Jan 30, 1:07 pm, dguillett1 dguille...@gmail.com wrote: UN tested but try Sub FilterDeleteColumnN() Application.ScreenUpdating=false with Range(N1:NRange(N Rows.Count).End(xlUp).Row) .AutoFilter Field:=1, Criteria1:= .offset(1).rows.delete .AutoFilter end with Application.ScreenUpdating=True end sub On Jan 30, 11:10 am, Sam Mathai Chacko samde...@gmail.com wrote: Try adding a line at the end of the code Application.ScreenUpdating=True Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Thomp Sent: Monday, January 30, 2012 12:39 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Checkbox disappears when Macro Run Here is the code Sam..when I added your code line it eliminates all the lines not just those completed Sub FilterDeleteColumnF() Dim Lastrow As Long Range(N:N).AutoFilter Field:=1, Criteria1:= Lastrow = Range(N Rows.Count).End(xlUp).Row If Lastrow 3 Then Range(A3:A Lastrow).SpecialCells(xlCellTypeVisible).EntireRow.Delete xlShiftUp ActiveSheet.AutoFilterMode = False On Jan 30, 11:10 am, Sam Mathai Chacko samde...@gmail.com wrote: Try adding a line at the end of the code Application.ScreenUpdating=True Regards, Sam Mathai Chacko On Mon, Jan 30, 2012 at 8:59 PM, Thomp williamth...@gmail.com wrote: I have this weird problem that whenever I run a macro I have the clears some data.. the checkbox control at the top disappears..Stranger still is if I drag the last row of data or copy and paste in a new row the checkbox reappears.. I have already tried changing the format control to the option of dont move or size with cells but that has no effect. The checkbox is from the control toolbox and is assigned a macro..just in case that makes a differenct.. thanks in advance for any help on this -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko- Hide quoted text - - Show quoted text - -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------ To post to this group, send email to excel-macros@googlegroups.com- Hide quoted text - - Show quoted text - -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ stuck with a password protected excel file
Dear All: You guys and gals have been so helpful to all my previous queries and I highly appreciate that... I am stuck again with Excel. This time with a Excel file which was password protected by my ex colleague. He somehow has forgotten the password and it seems there is no way to retrieve the information in it.. I have tried some tips that I found online like opening in google docs, but that does not work. I am too worried to use some online software to crack the password because the file contains sensitive contact information of our clients Is there any solution? Many many thanks and Mahalo for your help. Azeema -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ stuck with a password protected excel file
3) Don't post questions regarding breaking or bypassing any security measure. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Azeema Sent: Tuesday, January 31, 2012 3:53 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ stuck with a password protected excel file Dear All: You guys and gals have been so helpful to all my previous queries and I highly appreciate that... I am stuck again with Excel. This time with a Excel file which was password protected by my ex colleague. He somehow has forgotten the password and it seems there is no way to retrieve the information in it.. I have tried some tips that I found online like opening in google docs, but that does not work. I am too worried to use some online software to crack the password because the file contains sensitive contact information of our clients Is there any solution? Many many thanks and Mahalo for your help. Azeema -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ PivotByMultiSheet2
Thanks Rajan, but same problem continue, its better if you give me an example. On Tue, Jan 31, 2012 at 7:22 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Please try again with attached Add-ins. ** ** Rajan ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara *Sent:* Jan/Tue/2012 01:13 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ PivotByMultiSheet2 ** ** Thanks Rajan, but data not display in PivotSheet, anything wrong with me?* *** ** ** Ashish Bhalara On Tue, Jan 31, 2012 at 12:59 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Press Shift + Ctrl P and add the ranges to list box.. Range should have same column.. Not a single heading should be blank.. First it copy all range data to A temp sheet and Create a pivot table.. then it will delete that temp sheet.. With Pivot table all data will store in Pivot Cache you can retrieve the data again .. Thanks Rajan *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara *Sent:* Jan/Tue/2012 12:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ PivotByMultiSheet2 Dear Experts Kindly know me how to use the file of PivotByMultiSheet2 which I downloaded from your mails. Thanks regards Ashish Bhalara -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+
Re: $$Excel-Macros$$ Display numbers in Lakhs
This is really good, but gives answer in million format and not in Indian lakh. Regards On Sun, Jan 29, 2012 at 11:35 AM, Mohammed Muneer mmun...@ccc.com.qawrote: Mr. Prabhu go to Format cells: Go to Numbers - currency - select Indian RUPEES - Then immediately come out from currency and go to customs - do little correction like this (chk the att copy of jpg file Regards, Muneer, CC... -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Sunday, January 29, 2012 8:42 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Display numbers in Lakhs Hi, In Excel I needs to convert numbers in to indian format and the value should divided by lakhs and display in Lakhs. Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian format) Plz help. Regards, Prabhu -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Cloud Storage
Hi Is there anywhere online that MS Excel files can be stored and used. No look-a-likes but Excel. Freeware or low cost. Thanks Charlie -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Password protect hidden sheets
dear priyanka better you can hide data range and protect your sheet. instead of hiding whole sheet. or as sam said you can protect the workbook structure. @rajan other folks if the macros or disabled? if the codes are modified or deleted? On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Hi * * * *After hiding* worksheet.. paste this in worksheet code module ** ** Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect YourPassWord .Visible = *xlSheetHidden* StrPass = InputBox(kindly enter password to unprotect sheet)*** * If StrPass = YourPassWord Then .Unprotect YourPassWord .Visible = True Else MsgBox Incorrect Password,Woksheet can not be visible, vbCritical, Password Required End If End With End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Jan/Tue/2012 01:49 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Password protect hidden sheets ** ** Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:* *** Dear Team ** ** Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide ** ** I have excel 2007 version ** ** If any more details req kindly let me know ** ** Regards Priyanka -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ ** ** -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Great day,* *viper* -- FORUM RULES (986+ members already BANNED for
Re: $$Excel-Macros$$ Password protect hidden sheets
Dear Sam After protecting the sheet i cant hide it, and i want to hide it so other person can not see it, And password is req while unhidding the sheet is because if by mistake someone see the sheet and tries to unhide it , he cant do it w/o password SO is there anything like this ,except macro.. Noorain,Rajan and Sam . On Wed, Feb 1, 2012 at 12:38 PM, The Viper viper@gmail.com wrote: dear priyanka better you can hide data range and protect your sheet. instead of hiding whole sheet. or as sam said you can protect the workbook structure. @rajan other folks if the macros or disabled? if the codes are modified or deleted? On Tue, Jan 31, 2012 at 6:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Hi * * * *After hiding* worksheet.. paste this in worksheet code module ** ** Private Sub Worksheet_Activate() Dim StrPass As String With Me .Protect YourPassWord .Visible = *xlSheetHidden* StrPass = InputBox(kindly enter password to unprotect sheet)** ** If StrPass = YourPassWord Then .Unprotect YourPassWord .Visible = True Else MsgBox Incorrect Password,Woksheet can not be visible, vbCritical, Password Required End If End With End Sub ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* Jan/Tue/2012 01:49 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Password protect hidden sheets ** ** Hi priyanka, Try through below vba Code... Private Sub Worksheet_Activate() Sheet1.Protect 1823 Sheets(1).Visible = xlSheetVeryHidden Dim pass As String pass = InputBox(kindly enter password to unprotect sheet) If pass = 1823 Then Sheet1.Unprotect 1823 Sheets(1).Visible = True Else MsgBox Incorrect Password Worksheets(2).Activate End If End Sub On Tue, Jan 31, 2012 at 12:05 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Team ** ** Kindly let me know if i have a workbook having 3 sheets in it, and i hide 2 sheets of it and when next time i unhide those sheets a password box gets open and without password it can't be unhide ** ** I have excel 2007 version ** ** If any more details req kindly let me know ** ** Regards Priyanka -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ ** ** -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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
Re: $$Excel-Macros$$ excell to pdf
Dear Rajan I m getting error in below part wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False On Tue, Jan 31, 2012 at 8:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *See the final Version * ** ** Sub CreatePDF() Dim wksSheet As Worksheet Dim blnFlag As Boolean Dim intI As Integer Dim intResult As Byte intI = 0 intResult = Application.InputBox(Type 1 for Entire Workbook and Type 0 For Active Worksheets) If intResult = 0 Then Set wksSheet = ActiveSheet wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Exit Sub End If For Each wksSheet In ThisWorkbook.Worksheets If WorksheetFunction.CountA(wksSheet.Cells) 0 Then If wksSheet.Visible = xlSheetHidden Then wksSheet.Visible = xlSheetVisible blnFlag = True End If wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path \ wksSheet.Name, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False intI = intI + 1 If blnFlag = True Then wksSheet.Visible = xlSheetHidden blnFlag = False End If End If Next MsgBox intI Worksheet(s) has been Exported to PDF, vbInformation* *** End Sub ** ** Rajan ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *KAUSHIK SAVLA *Sent:* Jan/Tue/2012 08:28 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ excell to pdf ** ** Hi Rajan, ** ** Problem resolved. ** ** Excellent job to help us on this article. ** ** Regards, Kaushik -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Re: Solve problem,Plz help me
Instead of Pivot formulas can help u for it, vlookup and formula On Tue, Jan 31, 2012 at 8:44 PM, Veeru TOC veerub...@gmail.com wrote: Dear group, Plz help me ... On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, Can i use pivot table up to data came below type but i required this type of data Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains Fail 12:14:59 IN-1009598 Mains Fail 19:56:46 19:56:56 Rectifier Fail 19:56:46 Req data: indus id Text IN-1008993 DG on load 12:16,Mains fail 12:14 IN-1009598 Mains fail 19:56,Rectifier fail 19:56 plz find attachment of file *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh ** **91-9177-444-840**,* -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Cloud Storage
Yes Cab You can use google docs facility to use online excel. Click here for more information. edutech.msu.edu/*online*/*GoogleDocs*/*GoogleDocs*.html On Wed, Feb 1, 2012 at 12:05 PM, Cab Boose swch...@gmail.com wrote: Hi Is there anywhere online that MS Excel files can be stored and used. No look-a-likes but Excel. Freeware or low cost. Thanks Charlie -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- 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 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com