$$Excel-Macros$$ Re: Split tif page using EXCEL VBA
On Tuesday, July 10, 2012 7:34:49 PM UTC+5:30, Ganesh S wrote: > > > Hi All, > > I got the below coding from some other sites.. but while executing this > macro, i got error messages and i can't solve this coding issue. Please > help me to get resolve or any new coding to split tif images thru excel vba > macro. > > "* > > Option Explicit > > Dim ImageFile As Long > Dim BitMapImage As Long > > Private Sub cmdFile_Click() > cmdSplit.Enabled = False > > ' create a open dialog so that you can select > ' the multipage tiff to split > CommonDialog.InitDir = App.Path > CommonDialog.DialogTitle = "Select Multi Page TIFF" > CommonDialog.DefaultExt = "*.TIF" > CommonDialog.Filter = "TIF Files|*.TIF|TIFF Files|*.TIFF" > CommonDialog.ShowOpen > > If (Len(CommonDialog.Filename) > 0) Then > > ' apply the selected image to the Kodak > ' thumbnail control to display icons of the > ' different pages > imgThumb.Image = CommonDialog.Filename > imgThumb.Refresh > > ' use the FreeImage DLL to open the multipage > ' TIFF file, and use the GetPageCount function > ' to determine if there are multiple pages to > ' process > > ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _ > CommonDialog.Filename, False, True) > > If (FreeImage_GetPageCount(ImageFile) > 1) Then > cmdSplit.Enabled = True > End If > > ' update caption bar with filename + page count > Caption = CommonDialog.Filename & " " & _ > FreeImage_GetPageCount(ImageFile) & " page(s)" > > ' close the multi-page TIFF file > Call FreeImage_CloseMultiBitmap(ImageFile) > End If > End Sub > > > Private Sub cmdSplit_Click() > Dim pages As Integer > Dim i As Integer > > ' use the FreeImage DLL to open the multipage > ' TIFF file, and use the GetPageCount function > ' to determine if there are multiple pages to process > ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _ > CommonDialog.Filename, False, True) > > pages = FreeImage_GetPageCount(ImageFile) > > i = 0 > Do While i <= (pages - 1) > ' use the lock page function to copy that > ' page into a new variable BitMapImage > BitMapImage = FreeImage_LockPage(ImageFile, i) > > ' save that page out to a new filename > Call FreeImage_Save(FIF_TIFF, BitMapImage, _ > App.Path & "\page" & i + 1 & ".tif") > > ' unlock the page > Call FreeImage_UnlockPage(ImageFile, i, False) > > i = i + 1 > Loop > > ' close the multi-page TIFF file > Call FreeImage_CloseMultiBitmap(ImageFile) > > ' feedback to user that process is complete > MsgBox pages & " pages, split from " & _ > CommonDialog.Filename, vbInformation, "Complete" > End Sub > > * > > I will expect your views and suggestion to get solution for this coding. > Please let me know if you have any clairifications. > > Thanks & Regards, > Ganesh -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Split tif page using EXCEL VBA
Hi All, I got the below coding from some other sites.. but while executing this macro, i got error messages and i can't solve this coding issue. Please help me to get resolve or any new coding to split tif images thru excel vba macro. "* Option Explicit Dim ImageFile As Long Dim BitMapImage As Long Private Sub cmdFile_Click() cmdSplit.Enabled = False ' create a open dialog so that you can select ' the multipage tiff to split CommonDialog.InitDir = App.Path CommonDialog.DialogTitle = "Select Multi Page TIFF" CommonDialog.DefaultExt = "*.TIF" CommonDialog.Filter = "TIF Files|*.TIF|TIFF Files|*.TIFF" CommonDialog.ShowOpen If (Len(CommonDialog.Filename) > 0) Then ' apply the selected image to the Kodak ' thumbnail control to display icons of the ' different pages imgThumb.Image = CommonDialog.Filename imgThumb.Refresh ' use the FreeImage DLL to open the multipage ' TIFF file, and use the GetPageCount function ' to determine if there are multiple pages to ' process ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _ CommonDialog.Filename, False, True) If (FreeImage_GetPageCount(ImageFile) > 1) Then cmdSplit.Enabled = True End If ' update caption bar with filename + page count Caption = CommonDialog.Filename & " " & _ FreeImage_GetPageCount(ImageFile) & " page(s)" ' close the multi-page TIFF file Call FreeImage_CloseMultiBitmap(ImageFile) End If End Sub Private Sub cmdSplit_Click() Dim pages As Integer Dim i As Integer ' use the FreeImage DLL to open the multipage ' TIFF file, and use the GetPageCount function ' to determine if there are multiple pages to process ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _ CommonDialog.Filename, False, True) pages = FreeImage_GetPageCount(ImageFile) i = 0 Do While i <= (pages - 1) ' use the lock page function to copy that ' page into a new variable BitMapImage BitMapImage = FreeImage_LockPage(ImageFile, i) ' save that page out to a new filename Call FreeImage_Save(FIF_TIFF, BitMapImage, _ App.Path & "\page" & i + 1 & ".tif") ' unlock the page Call FreeImage_UnlockPage(ImageFile, i, False) i = i + 1 Loop ' close the multi-page TIFF file Call FreeImage_CloseMultiBitmap(ImageFile) ' feedback to user that process is complete MsgBox pages & " pages, split from " & _ CommonDialog.Filename, vbInformation, "Complete" End Sub * I will expect your views and suggestion to get solution for this coding. Please let me know if you have any clairifications. Thanks & Regards, Ganesh -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Excel Macro Code Request for List files and Move specified directory
Dear all, Please find below is my request to create macro code: Step1: Browse Directory. Step2: List files in above selected directory. Step3: Create directory based on the file Step4: Move files based on its named directory. Please help us to get this process solution. Please let me know if you have any clarifications in this regard. * * -- 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 directorycreation.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Date : Illogical date checking in a entire column
Hi All, I have a table and one column is entered date. Example: B1:B500 I want to check all the dates are entered correctly and if there is any illogical dates within it. Default date format is mm/dd/.. Please help me... with excel macro to solve this as easier way to find.. Please let me know if you did not understand my request.. thanks & regards, ganesh -- 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$$ delete row only the next mob no same
*hi, it will help U* Public Sub DeleteDuplicateRows() Dim R As Long Dim N As Long Dim V As Variant Dim Rng As Range On Error GoTo EndMacro Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set Rng = Application.Intersect(ActiveSheet.UsedRange, _ ActiveSheet.Columns(ActiveCell.Column)) Application.StatusBar = "Processing Row: " & Format(Rng.Row, "#,##0") N = 0 For R = Rng.Rows.Count To 2 Step -1 If R Mod 500 = 0 Then Application.StatusBar = "Processing Row: " & Format(R, "#,##0") End If V = Rng.Cells(R, 1).Value If V = vbNullString Then If Application.WorksheetFunction.CountIf(Rng.Columns(1), vbNullString) > 1 Then Rng.Rows(R).EntireRow.Delete N = N + 1 End If Else If Application.WorksheetFunction.CountIf(Rng.Columns(1), V) > 1 Then Rng.Rows(R).EntireRow.Delete N = N + 1 End If End If Next R EndMacro: Application.StatusBar = False Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic MsgBox "Duplicate Rows Deleted: " & CStr(N) End Sub On Fri, Jan 22, 2010 at 12:10 PM, manoj kumar wrote: > Hi Sir > > I have a list of several thousands email in it but there are so many > emails same > > I have sorted the list but cannot delete all the files which are > copied of the above row > > please help > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help Required - Gantt Chart
hi, check this file i created it will help U. pl give me feedback on this On 1/20/10, Rakesh Sharma <> wrote: > > Hi Maniyan, > > Here is the solution which I think my help you. > > > > Regards > Rakesh > > -- > The INTERNET now has a personality. YOURS! See your Yahoo! > Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> > . > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > > -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Gantt Chart(demo).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ help
hi thanks. i did it. it exactly to mine requirement. thank you to all guys u tooo On Wed, Jan 20, 2010 at 3:00 PM, Santhosh Kumar M K wrote: > Hi Ganesh, > > Please find attachment.Let me know any further..Thanks > > Regards, > Santhosh > Bangalore > > On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw wrote: > >> hi guys, >> i want to concatenate date with week but am not able to do that. so pl >> assist me. he showing some value after concatenation. >> am attaching a file. Pl assist me. >> >> -- >> Ganesh Gawde >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help
thanks abhishek, is done . thank you to all . On Wed, Jan 20, 2010 at 2:20 PM, Abhishek Jain wrote: > Dear Ganesh, > > Use this - > > *=CONCATENATE(TEXT(A21,"dd-mmm")," whose week is ",B21)* > > Change the format "dd-mmm" as whichever you like. > > Best regards, > > AJ > > > On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw wrote: > >> hi guys, >> i want to concatenate date with week but am not able to do that. so pl >> assist me. he showing some value after concatenation. >> am attaching a file. Pl assist me. >> >> -- >> Ganesh Gawde >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help
*Hi santosh, *thanks for quick reply.* * *1/20/2010 * *17-Jan to 23-Jan* * * *40198 whose week is 17-Jan to 23-Jan* * on 40198 i want to show my DATE that is 1/20/2010 whose week is 17-Jan to 23-Jan i want to concatenate the value which i calculate in B2 coloumn* On Wed, Jan 20, 2010 at 12:57 PM, Santhosh Kumar M K wrote: > Hi Ganesh, > > Please find attached file. I made some changes.Please refer. I think it > will help to you. Thanks > > Regards, > Santhosh,Bangalore > > On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw wrote: > >> hi guys, >> i want to concatenate date with week but am not able to do that. so pl >> assist me. he showing some value after concatenation. >> am attaching a file. Pl assist me. >> >> -- >> Ganesh Gawde >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Overriding excel Default charts
Once you click on the excel & add a Bar chart from the standard, it inserts the chart with a excel formatting like color, background, border etc. The formatting is a excel standard chart, how can I override this to have formatting specific to my organization. Where are these templates saved in the machine & how to edit it. or can I add a separate tab for my organization in the chart wizard? Thanks Ganesh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Data Validation Help
Please find attachd as required by you, I have used "IF", let m know if it was useful On Thu, Apr 9, 2009 at 11:51 AM, Harmeet Singh wrote: > Try attached file > > On Wed, Apr 8, 2009 at 9:06 PM, anish@gmail.com > wrote: > >> >> Hello Experts, >> >> I have been a silent member of this group and learnt so many >> things...But now I am facing a new problemI hope anyone of you can >> help me out..Problem is as below... >> >> I have 2 lists in Column "A" and "B" (as u can see below) and I have >> validated them in Column C and D. >> Now what I need is if I select "2" in column C then Column D should >> list only 2 or more than 2 numbers. we dont need 1 there. Same goes >> for each number. Whatever we select in Column C, Column D should list >> only dat number or numbers more than that. I hope I was clear in what >> I need. It's quite urgent so would expect some urgent response from >> you. >> >> >> A B C D >> 11 2 >> 22 >> 33 >> 44 >> 5 5 >> 66 >> 77 >> 88 >> 99 >> 10 10 >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > > > -- Ganesh Babu K --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Book1(1).xls Description: MS-Excel spreadsheet