RE: $$Excel-Macros$$ saving particular worksheets in a fresh workbook

1.You don't need to select the sheets to copy the sheets. The select is serving no useful function in that code. 2.The default destination for a copy is a new workbook, which will become the active workbook. is that your intent? Otherwise, the code seems to work. Here is the help for the

Re: $$Excel-Macros$$ saving particular worksheets in a fresh workbook

Well its working fine on my PC. Can you share an example file? On Thu, Mar 1, 2012 at 11:46 AM, Shankar Bheema wrote: > I tried the following code and during execution the following error is > coming. > > run time error 9, > Subscript out of range. > > Pls provide solution. > > regards > shankar

$$Excel-Macros$$ How to unsubscribe from excel-macros

TO UNSUBSCRIBE Google Groups help on the subject: http://support.google.com/groups/bin/answer.py?hl=en &answer=46608 Key points thereof: Leave the group by any of these methods: .Reply to any group email and change the

Re: $$Excel-Macros$$ saving particular worksheets in a fresh workbook

I tried the following code and during execution the following error is coming. run time error 9, Subscript out of range. Pls provide solution. regards shankar sb On Wed, Feb 29, 2012 at 4:28 PM, Shankar Bheema wrote: > thank you abhishek > > > On Wed, Feb 29, 2012 at 12:11 PM, Abhishek Jain wr

RE: $$Excel-Macros$$ Avg. Revisit in number of days

Dear Don, Did you got chance to refer my query. Best Regards, Amit From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com] Sent: 27 February 2012 00:28 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Avg. Revisit in number of days Dear Don, Please refer attached sheet...see

RE: $$Excel-Macros$$ Suppress the Disable Macros / Enable Macros Dialog.

Hello Mari, To add to the other comments, there is an alternative: Get a code signing certificate from a trusted authority and sign your VBA project. Default trust settings in Excel allow signed code (with a trusted authority) to run. You can verify what trust settings the client uses to ensure

$$Excel-Macros$$ Re: calculate from multiple sheets & calculate from multiple sheets with conditions

Hello Sundarvelan, Assume your sheet name always be in dd-mmm-yy format, if so see the attached. In Summary B1 & B2, enter the Start & End Date, So this will calculate results between these sheets. ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use con

RE: $$Excel-Macros$$ indirect function help

=SUM(INDIRECT("'"&A6&"'!G:G")) -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of LearnExcel Sent: Wednesday, February 29, 2012 2:34 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ indirect function help HI team, can you ple

Re: $$Excel-Macros$$ indirect function help

Due to spaces in sheet name. I ALWAYS avoid. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: LearnExcel Sent: Wednesday, February 29, 2012 4:33 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ indirect function help HI team, can you please help ou

$$Excel-Macros$$ Re: indirect function help

If you have space in the sheet name will require an apostrophe before 7 after the sheet name. When ever you use INDIRECT use the apostrophe. excel will ignore, If doesn't require it. So use like this, *=SUM(INDIRECT("'"&A6&"'!G:G"))* ___ HTH, Haseeb -- FORUM RULES (986+ members alread

$$Excel-Macros$$ indirect function help

HI team, can you please help out on the following I'm using a indirect function but i'm unalbe to get it to work in cell "A6" if there ia name "sheet2" the forluma works just fine but when the sheet name is "My Main File" it proivded an REF error is there a rix for this? =SUM(INDIRECT(A6&"!G:G

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

range("a2:z223").copy range("a1").paste pastevalues Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Scruffy Huffy Sent: Wednesday, February 29, 2012 3:51 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied Don,

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

Don, Thanks for the suggestion. Any ideas on what to do when the source and destination are merged cells of different sizes? Right now, I'm copying the source value to a random cell in the workbook, and then copying that value to the destination merged cells. That just seems clumsy, though. An

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

Sam, That was very helpfulI was missing the code line "Application.CutCopyMode = False". That took care of the "ant trail". Thanks Again! Robb On Feb 29, 2:46 pm, Sam Mathai Chacko wrote: > SH, I'd suggest you try recording macro and after you perform the copy > paste special as values, c

Re: $$Excel-Macros$$ Urgent: Need Help (Assignment)

Apparently, you are right. I thought I saw it in there somewhere. Probably another forum. I guess it should be added. And yeah, I am of the same opinion too. A homework is a homework, and as you said, to learn it, YOU have to DO it. Sam On Thu, Mar 1, 2012 at 2:17 AM, dguillett1 wrote: > Sam,

Re: $$Excel-Macros$$ Urgent: Need Help (Assignment)

Sam, I don’t think the “published” rules prohibit that. I just make it my policy to encourage posters to learn by doing so I don’t do homework. YMMV Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Wednesday, February 29, 2012 2:02 PM To: excel-macros@googlegrou

Re: $$Excel-Macros$$ Urgent: Need Help (Assignment)

Well I thought I'd give it to him for the honesty, but then, can't go against the rules. Speaking of excel classes, I wish we had that back in those days. Sam On Thu, Mar 1, 2012 at 1:10 AM, dguillett1 wrote: > Is this “homework” for an excel class? > > Don Guillett > SalesAid Software > dgui

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

This will copy just the values from the source to the dest. Ranges MUST be the same size range(destination).value=range(source).value This is much better and the same as range(source).copy range(dest).paste.pastespecial Don Guillett SalesAid Software dguille...@gmail.com -Original Message-

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

SH, I'd suggest you try recording macro and after you perform the copy paste special as values, check the macro, you should find how to write the code. Sam On Thu, Mar 1, 2012 at 1:11 AM, Scruffy Huffy wrote: > Sam, > > I've already tried thatbut it doesn't remove the animation around > the

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

Sam, I've already tried thatbut it doesn't remove the animation around the cell that I copied from. I guess I really need a "double-click" option, rather than just a "select" option. I could select fifty different cells in succession, and still not remove the original animated cursors. Also

Re: $$Excel-Macros$$ Urgent: Need Help (Assignment)

Is this “homework” for an excel class? Don Guillett SalesAid Software dguille...@gmail.com From: Mani Sent: Wednesday, February 29, 2012 11:27 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent: Need Help (Assignment) Hi Guys, I am new in excel and have to do this assignmen

Re: $$Excel-Macros$$ "Un-selecting" a cell being copied

The trick is to select another cell... at any given time, at least one cell WILL be selected (if not any other object) in a sheet. So at the end of your macro, select any other cell, for example the top left cell A1 Sam Mathai Chacko On Thu, Mar 1, 2012 at 12:12 AM, Scruffy Huffy wrote: > This

$$Excel-Macros$$ "Un-selecting" a cell being copied

This problem is a bit difficult to describe, but here goes. I'm using a command button macro to select a cell, copy its value, then past the value to another cell. However, I don't know the code to "de-select" the copied cell. In other words, after the copy/paste is complete, the cell that I co

$$Excel-Macros$$ Urgent: Need Help (Assignment)

Hi Guys, I am new in excel and have to do this assignment in very less time. Could you please suggest an answer to the following problem. Many thanks in advance. (Write a formula to pull out the name of the publisher for country with <1st> largets revenue) Country Publisher Revenue A Alpha 10

$$Excel-Macros$$ step by step the result

Dear Grpou Member,   Look at the attached file this solution was posted by Mr. NOORION. I was trying to understand step by step the result. But I m unable to understand “INDIRECT”. Can anyone clarify the steps.   Regards LAKSHMAN -- FORUM RULES (986+ members already BANNED for violation) 1) Us

Re: $$Excel-Macros$$ Formula not working

=IF(AND(AND(A2>=126,A2<=375),(B2>=500)),10,0) On Wed, Feb 29, 2012 at 10:57 PM, Jorge Marques wrote: > Hi guys, i don´t know, how is this, my formula is wrong, if i change the > weight beyond the limits it keeps giving 10. how can i change this, i think > it´s simple, but i´m not finding a solu

$$Excel-Macros$$ Formula not working

Hi guys, i don´t know, how is this, my formula is wrong, if i change the weight beyond the limits it keeps giving 10. how can i change this, i think it´s simple, but i´m not finding a solution. Thank you -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ ODBC data from Tally

first install tally odbc driver then user odbc for more information please find the below link http://www.tally9.info/2009/10/connectivity-using-tally-erp9-using-htmlodbc-xml-and-synchronization/ On Wed, Feb 29, 2012 at 8:54 PM, Ashish Bhalara wrote: > Dear expert, > > I require the data from

Re: $$Excel-Macros$$ Re: sheet updation macro

Send file Don Guillett SalesAid Software dguille...@gmail.com From: Avinash Sent: Wednesday, February 29, 2012 9:26 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: sheet updation macro Dear Don Guillett / Maries , i saw your previous reply for the subject If I input Let

$$Excel-Macros$$ Re: sheet updation macro

Dear Don Guillett / Maries , i saw your previous reply for the subject If I input Letter Y is should show the current date i guess it is bit similar to that post but i am not able to get this done i tried to use your vba code in to my sheet and instean of "Y" i have changed this to true so

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

range uses Range9(“a1:z21”) cells uses cells(1,1) or cells(1,”a”) for Row first and column second. result is the same Don Guillett SalesAid Software dguille...@gmail.com From: Jorge Marques Sent: Wednesday, February 29, 2012 5:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Yes that´s what i thought, just wasn´t sure about the Cells(Rows.Count, 1). well thank you very much once again :). 2012/2/29 ChilExcel > Don Guillett > > Great contribution, thanks Don Guillett > > Chilexcel > 2012/2/29 Sam Mathai Chacko > >> Just a guess without testing >> >> For i = Cells(Ro

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

Or this which copies template to the end. Private Sub Workbook_Open() Dim mydate As String mydate = Format(Date, "dd-mm-") With Sheets(Sheets.Count) If .Name <> mydate Then Sheets("Template").Copy after:=Sheets(.Index) ActiveSheet.Name = mydate End If End With End Sub Don Guillett SalesAid So

Re: $$Excel-Macros$$ calculate from multiple sheets & calculate from multiple sheets with conditions

Hello Friends, Can i achive this using formula. Thanks N.Sundarvelan 9600160150 On Wed, Feb 29, 2012 at 6:47 PM, Shaik Waheed wrote: > How abt getting the same with the multiples sheet pivot. Here is what i > had tried, u can select required fields from value filter. > > > On Wed, Feb 29, 201

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Don Guillett Great contribution, thanks Don Guillett Chilexcel 2012/2/29 Sam Mathai Chacko > Just a guess without testing > > For i = Cells(Rows.Count, "Z").End(xlUp).Row To 2 Step -1 > If Cells(i + 1, "Z") = Cells(i, "Z") Then > > Sam > > > On Wed, Feb 29, 2012 at 4:41 PM, Jorge Marques wrote:

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Just a guess without testing For i = Cells(Rows.Count, "Z").End(xlUp).Row To 2 Step -1 If Cells(i + 1, "Z") = Cells(i, "Z") Then Sam On Wed, Feb 29, 2012 at 4:41 PM, Jorge Marques wrote: > Sorry my friends for writting again in the post, it just that i understood > this code, the only thing i

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

Dear Sundar, Wrong attachment, Please ignore it.. On Wed, Feb 29, 2012 at 6:21 PM, NOORAIN ANSARI wrote: > Dear Sundar, > > Please see attached sheet, you can use.. > > Sub Count_VBA() > On Error Resume Next > c = 1 > For Each Sh In ActiveWorkbook.Sheets > If Sh.Name <> Sheets("Summary") Then >

Re: $$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

First: save your file as .xlsb or .xlsm... Then create a Workbook Open event macro in the Thisworkbook module: Private Sub Workbook_Open()     Dim Sht     Err.Clear     On Error Resume Next     Sht = Format(Now(), "dd-mmm-yy")     Sheets(Sht).Select     If (Err) Then     Sheets("TEMPLATE").Co

$$Excel-Macros$$ calculate from multiple sheets & calculate from multiple sheets with conditions

Hi Freinds, help me to achieve this task. COUNT OF TOTAL EMPLOYEES 168 COUNT OF DRIVER AND SWEEPER 56 Thanks N.Sundarvelan 9600160150 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ rounding off problem

Hi, ** *Try it in Userform:* Private Sub CommandButton1_Click() TextBox2.Text = WorksheetFunction.Ceiling((Val(TextBox1.Text) * 0.03) - 0.8, 10) End Sub Regards, MARIES. On Wed, Feb 29, 2012 at 2:58 PM, Shankar Bheema wrote: > Dear Experts > > The above attached file contains an userform for r

$$Excel-Macros$$ Re: step by step the result

Dear Lakshman, Please click here, It will very usefull to understand "INDIRECT" and "Address" Function Combination.. http://www.contextures.com/xlFunctions05.html http://www.informit.com/articles/article.aspx?p=433385 On Wed, Feb 29, 2012 at 4:05 PM, LAKSHMAN PRASAD wrote: > Dear Grpou Member,

$$Excel-Macros$$ Copy Sheet and Name the sheet with todays date

Hi Friends, I need a help in my project. I have excel file in which template sheet is constant. When i open that file in the morning it should copy the template sheet and rename the sheet with todays date. In the same day i will be closing and opening that file many times but it should not insert

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Sorry my friends for writting again in the post, it just that i understood this code, the only thing i don´t get is if the control cell is Z and not A, how can i change it, because, i have a another report that is exactly like the initial post but now the control is not A- Order but cell Z - Shop,

$$Excel-Macros$$ rounding off problem

Dear Experts The above attached file contains an userform for rounding off of the value if the 3% of the given value comes to more than multiple of 10 except the fraction that value should be rounded off to the nearest multiple of 10 ex. if the value of 3% comes to 660.01 or 660.50 or 660.99 th

Re: $$Excel-Macros$$ is there possibility of conditional formatting based upon nested conditions

You're welcome. While still on the subject...excel conditional formatting offers 4 conditions already. 1, 2, 3 and the 'else' part gives a choice for 4th formatting (default). Also for more than 03 conditions, below link offers some ideas. http://www.ozgrid.com/Excel/font-formats.htm Thanks & r

Re: $$Excel-Macros$$ Unsubscribe

Dear Group Owner,   I am required link of Unsubscribe only my lakshman...@yahoo.com ID   LAKSHMAN -- 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 A