$$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.
Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.
Sub etst() Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets On Error Resume Next ws.Visible = xlSheetVisible Next End Sub On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav jayendra.gau...@gmail.com wrote: Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.
Dear Jayendra, Please try below Code... Sub Unhide_all_sheets() Dim c, i As Integer application.ScreenUpdating=False c = ActiveWorkbook.Sheets.Count For i = 1 To c Sheets(i).Visible = True Next i application.ScreenUpdating=False End Sub On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav jayendra.gau...@gmail.com wrote: Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.
Try this Sub UnhideAllHideen() For each sh in ActiveWorkbook.Sheets If sh.visible=False then sh.visible=True Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, August 24, 2011 1:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go. Sub etst() Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets On Error Resume Next ws.Visible = xlSheetVisible Next End Sub On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav jayendra.gau...@gmail.com wrote: Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.posterous.com/ http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.
u can try this code... *Sub UnhideAllSheets()* *Dim wsSheet As Worksheet* * * *For Each wsSheet In ActiveWorkbook.Worksheets* *wsSheet.Visible = xlSheetVisible* *Next wsSheet* *End Sub* Best, MKV On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav jayendra.gau...@gmail.com wrote: Team, I have hide 50 sheet in a work book kindly suggest me how can I Unhide all the hidden sheet in a single go. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ how to delete multiple row columns
It should work as desired for the active sheet. Try it. I need to correct lr to lc as below. Sub cleanrowsandcolumnsSAS() lr = Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row + 1 lc = Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByColumns, xlPrevious).Column + 1 Application.EnableEvents = False Rows(lr).Resize(Rows.Count - lr).Delete Columns(lc).Resize(, Columns.Count - lc).Delete Application.EnableEvents = True ActiveWorkbook.Save End Sub From: Amit Desai (MERU) Sent: Tuesday, August 23, 2011 10:36 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ how to delete multiple row columns Thanks a lot for the solution. Can you tell me how shall I use this? I mean How shall I paste this code so that macro works.. hope it will delete only blank cells on the right bottom !!!-:) From: excel-macros@googlegroups.com [excel-macros@googlegroups.com] On Behalf Of STDEV(i) [setiyowati.d...@gmail.com] Sent: Wednesday, August 24, 2011 6:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ how to delete multiple row columns A little correction Sub cleanrowsandcolumnsSAS() lr = Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row + 1 lc = Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByColumns, xlPrevious).Column + 1 Application.EnableEvents = False Rows(lr).Resize(Rows.Count - lr).Delete Columns(lc).Resize(, Columns.Count - lr).Delete Application.EnableEvents = True ActiveWorkbook.Save End Sub '--thank you siti Vi On Tue, Aug 23, 2011 at 7:37 PM, dguillett1 dguille...@gmail.com wrote: If I understand your request, you may like this. It also saves the file Sub cleanrowsandcolumnsSAS() lr = Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByRows, xlPrevious).Row lc = Cells.Find(*, Cells(Rows.Count, Columns.Count) _ , , , xlByColumns, xlPrevious).Column Application.EnableEvents = False Rows(lr).Resize(Rows.Count - lr).Delete Columns(lc).Resize(, Columns.Count - lr).Delete Application.EnableEvents = True ActiveWorkbook.Save End Sub From: Amit Desai (MERU) Sent: Tuesday, August 23, 2011 1:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ how to delete multiple row coulmns Dear All, Please let me know how to delete multiple rows(say from my last data based row # 678 to last row) multiple columns (say from AA to last column). This is taking a lot of file sizeā¦ Best Regards, Amit Desai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important
Re: $$Excel-Macros$$ Need a Formula or Macro
If you didn't solve this, I'll take a look? -Original Message- From: Baby Patel Sent: Thursday, August 18, 2011 8:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro Hi All, Please find the attchement. All these data are here in the zipped file. You can use price list to find the details. Thanks and regards, Smriti On 8/18/11, dguillett1 dguille...@gmail.com wrote: It would be very helpful if your data could result in an actual case with a real example. You ask to search for data that does NOT exist. -Original Message- From: Baby Patel Sent: Wednesday, August 17, 2011 8:08 AM To: excel-macros Subject: $$Excel-Macros$$ Need a Formula or Macro Hi Guys, I need an urgent help . Attached is the excel file for your reference. Issue : I want the result in the F coulmn of Sheet1. the Sku #from Coulmn B of Sheet 1 will be searched in A column of sheet2. If the SKU was found then it will check the Currency and Margin (B C column of Sheet 1) with Currency and Price Level ( B C column of Sheet2). If it matches then , it will take the respective value from column G of sheet 2 and will pop in column F of sheet1. Anyhelp will be highly appreciated. Thanks and regards, Smriti -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Error - **PASTE EXCEL CELLS HERE**
Hello, I am getting **PASTE EXCEL CELLS HERE** error(Range Not found) when I send mail by using vba code. Please let me know whats the error is. Thanks, Chandru -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need a Formula or Macro
thanks for your assistance. Please take a look. Earlier did not work. Thanks, Smriti On 8/24/11, dguillett1 dguille...@gmail.com wrote: If you didn't solve this, I'll take a look? -Original Message- From: Baby Patel Sent: Thursday, August 18, 2011 8:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro Hi All, Please find the attchement. All these data are here in the zipped file. You can use price list to find the details. Thanks and regards, Smriti On 8/18/11, dguillett1 dguille...@gmail.com wrote: It would be very helpful if your data could result in an actual case with a real example. You ask to search for data that does NOT exist. -Original Message- From: Baby Patel Sent: Wednesday, August 17, 2011 8:08 AM To: excel-macros Subject: $$Excel-Macros$$ Need a Formula or Macro Hi Guys, I need an urgent help . Attached is the excel file for your reference. Issue : I want the result in the F coulmn of Sheet1. the Sku #from Coulmn B of Sheet 1 will be searched in A column of sheet2. If the SKU was found then it will check the Currency and Margin (B C column of Sheet 1) with Currency and Price Level ( B C column of Sheet2). If it matches then , it will take the respective value from column G of sheet 2 and will pop in column F of sheet1. Anyhelp will be highly appreciated. Thanks and regards, Smriti -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User Defined formula in Excel
Hey Atul, Please find the below links, http://www.ozgrid.com/VBA/Functions.htm http://www.codeproject.com/KB/macros/excelmvf.aspx http://www.vertex42.com/ExcelArticles/user-defined-functions.html On Tue, Aug 23, 2011 at 11:42 PM, Atul vishwakarma atulkuma...@sify.comwrote: Hi Rajan, Due to some reason I was unable to access internet so i could not check my emails. I used the below codes and it is working fine. It was just an example to understand how to create user defined formulas in excel and make it permanent for any excel files. Thank you so much for time and help. Regards, Atul On Wed, Aug 17, 2011 at 1:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this Function Result(a as double,b as double, x as double) as double Result = (a*x)+ b End Function Once you define any Public Function in VBA those are available to Use on WOrkhseet , if you want to make this Function for application You can make add-ins or you can also save this function in Personal Macro Workbook Code Module, Hope it will heps -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com ] On Behalf Of Atul Sent: Tuesday, August 16, 2011 11:04 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ User Defined formula in Excel Hi, Is there any way to defined a user defined formula in excel which will work like default functions e.g. Sum, Average etc. Suppose I want to insert a formula to solve the equation y=ax+b So I will just give the value of a, b and x so it will return the required value of Y and this function will be appear with pre-defined functions (Sum, Average, Count). I hope any macro is possible to do this. Looking forward to hear from all excel gurus for this problem. Thanks! Regards, Atul -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Error - **PASTE EXCEL CELLS HERE**
please send vba code... On Wed, Aug 24, 2011 at 7:52 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, I am getting **PASTE EXCEL CELLS HERE** error(Range Not found) when I send mail by using vba code. Please let me know whats the error is. Thanks, Chandru -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet
Help: I have 40 spreadsheets in one workbook. I update the spreadsheets daily. I want the last row (Values) on all 40 spreadsheets copied to a summary sheet everyday after I update the data. How do you do this? After the data is summarized and I review it I will then delete the data in the summary sheet and repeat the process the following day. Thx, Clint -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet
Hi Can you attach the sample file . also do you like to copy complete row or any specific cells only On Wed, Aug 24, 2011 at 11:15 PM, Clint Stevens clintontstev...@gmail.comwrote: Help: I have 40 spreadsheets in one workbook. I update the spreadsheets daily. I want the last row (Values) on all 40 spreadsheets copied to a summary sheet everyday after I update the data. How do you do this? After the data is summarized and I review it I will then delete the data in the summary sheet and repeat the process the following day. Thx, Clint -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel