Re: $$Excel-Macros$$ VBA to copy data to a template file then save it as a new file

Your request should be File, it is best to have one sheet to copy. 2013/9/10 Chih Hung Choo choochihh...@gmail.com Hi, I'm hoping to get some help here to automate the work that I have to do every 2 weeks. The work is repetitive and hopefully a VBA script will help shorten sometimes a

Re: $$Excel-Macros$$ Macro needed to add worksheet

Thanks for the help but it's not adding my sheet in rest of the workbooks. i have attached that single sheet added the macro in it.Please suggest Where i'm going wrong. On Monday, September 9, 2013 8:16:20 PM UTC+5:30, ashish wrote: Sub copy_sheet() Application.ScreenUpdating = False

RE: $$Excel-Macros$$ Macro needed to add worksheet

Try this and change you folder name accordingly . Sub copy_sheet() Application.ScreenUpdating = False Application.DisplayAlerts = False primewb = ActiveWorkbook.Name Dim fld As Object, fil As Object, fso As Object Dim wkb As Workbook Set fso =

$$Excel-Macros$$ test

-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Need a formula urgently

Hi Rajan, Your file is rally awesome and great. I would like to learn this, do you have any explanatory notes on the functions used in this file so that I will learn to do this. On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma rajansharma9...@gmail.comwrote: Hi Murali, Chek the attachment too.

$$Excel-Macros$$ Copy Formula Answer to new sheet (next available cell) and REMAIN

Hi All, I have say a worksheet that is calculating cells A1:A9 with the Total being displayed in cell A10 I want the answer of the Sum Function in cell A10 to be copied to cell A1 in a different worksheet named say TOTALS Easy enough but here is what I want to be able to do: When the data

Re: $$Excel-Macros$$ Copy Formula Answer to new sheet (next available cell) and REMAIN

Yess that possible by using VBA, just follow attached workbook Pada 10/09/2013 20:23, georgebeegl...@gmail.com menulis: Hi All, I have say a worksheet that is calculating cells A1:A9 with the Total being displayed in cell A10 I want the answer of the Sum Function in cell A10 to be copied to

Re: $$Excel-Macros$$ Macro needed to add worksheet

is it giving you any error On Tue, Sep 10, 2013 at 2:54 PM, Ravi Kumar excellearn2...@gmail.comwrote: Try this and change you folder name accordingly … ** ** ** ** Sub copy_sheet() ** ** Application.ScreenUpdating = False Application.DisplayAlerts = False ** **

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

If you want to select current sheet, Use*ActiveSheet *to select it, not ActiveWorkbook *ActiveSheet*.Unprotect bla...bla...bla... *ActiveSheet*.Protect Pada 10/09/2013 21:52, ITP Abdulgani Shaikh menulis: Dear Sir, This sheet is again giving problem, please see attachments. When I am

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

Yes got it, but active sheet is password protected, any solution for that. On Tue, Sep 10, 2013 at 8:29 PM, De Premor d...@premor.net wrote: If you want to select current sheet, Use* ActiveSheet *to select it, not ActiveWorkbook *ActiveSheet*.Unprotect bla...bla...bla...

Re: $$Excel-Macros$$ Copy Formula Answer to new sheet (next available cell) and REMAIN

Thank You much De Premor. Very much appreciated -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

If you sheet protected by a password, you can add a password on next statement Before doing some change on sheet, add this line ActiveSheet.Unprotect MySheetPassword and after done with it, lock it again by using the same password ActiveSheet.Protect MySheetPassword Pada 10/09/2013

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

Yes, working fine. Can you please explain me Birth.Interior.Pattern = xlSolid PANo.Interior.Pattern = xlSolid and when we are entering Birthdate using other than / it gives error, instead of debug error, can we put error message. Regards On Tue, Sep 10, 2013 at 8:48 PM, De

$$Excel-Macros$$ am getting compile error

Hi experts, Please find below simple codes, while i run the macro am getting compile error. Please help to know what is the mistake i have done with this code. Sub sample() Sheets(sheet2).Range(A10).Value = 1000 Sheets(sheet2).Activate Sheets(sheet2).Range(A10).Select MsgBox Task Completed

Re: $$Excel-Macros$$ am getting compile error

Dear Prabhu, Use this code Sub sample() Sheets(sheet2).Range(A10).Value = 1000 Sheets(sheet2).Activate Sheets(sheet2).Range(A10).Select MsgBox Task Completed If MsgBox(Do you want to Clear the data ?, vbYesNo, Confirm) = vbYes Then Range(A:A).ClearContents MsgBox Data has been cleared Else

RE: $$Excel-Macros$$ am getting compile error

Its working fine just correct the position of then of if From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Wednesday, September 11, 2013 10:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ am getting compile error Hi