$$Excel-Macros$$ VBA help to auto collapse groups based on cell values

Hi, We are trying to create a toggle button to auto collapse/expand multiple groups dynamically. At the moment we have to name each group in the Names Manager and then manually have an if statement in VBA code where hard-code each groups name. However, we will have more than 100 groups so it

Re: $$Excel-Macros$$ VBA Help

Thank you very much. I'm learning VBA Thanks N.Sundarvelan 9600160150 On 19 August 2016 at 22:34, mrExcel4u wrote: > Hi, > Please use the below mentioned code on Add command Button click > > Private Sub CommandButton1_Click() > > Dim Rcount As Integer > > Rcount =

Re: $$Excel-Macros$$ VBA Help

Hi, Please use the below mentioned code on Add command Button click Private Sub CommandButton1_Click() Dim Rcount As Integer Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row Rcount = Rcount + 1 Range("b" & Rcount).Value = Me.TextBox1.Value ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value

$$Excel-Macros$$ VBA Help

Dear Friends, I'm trying to learn VBA, PFA, i'm trying to add data from userform text to excel table. Please help Thanks N.Sundarvelan 9600160150 -- 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 @

Re: $$Excel-Macros$$ VBA help required for specific Output from Input

Great!! ᐧ On Tue, Jan 20, 2015 at 6:34 PM, sach so itssac...@gmail.com wrote: Dear Vabz, Thanks! It works as i required. Regards, Sachin On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote: Sach, Amended code to suits your need.. Cheers!! On Fri, Jan 16, 2015 at 5:28

Re: $$Excel-Macros$$ VBA help required for specific Output from Input

Dear Vabz, Thanks! It works as i required. Regards, Sachin On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote: Sach, Amended code to suits your need.. Cheers!! On Fri, Jan 16, 2015 at 5:28 PM, sach so itss...@gmail.com javascript: wrote: Dear Expert, I required some

Re: $$Excel-Macros$$ VBA help required for specific Output from Input

Sach, Amended code to suits your need.. Cheers!! On Fri, Jan 16, 2015 at 5:28 PM, sach so itssac...@gmail.com wrote: Dear Expert, I required some changes in VBA, file attached here. I have data sheet, for Input i have input sheet for output have output sheet. when I run macro i will get

$$Excel-Macros$$ VBA help required for specific Output from Input

Dear Expert, I required some changes in VBA, file attached here. I have data sheet, for Input i have input sheet for output have output sheet. when I run macro i will get output. *My requirment- *In data sheet if product product id is allocated then macro need to pick next (non allocated)

Re: $$Excel-Macros$$ VBA help

Hi Can you share sample data with desired result.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 1:17 PM, Mandeep Baluja rockerna...@gmail.com wrote: I have made this code for I have two worksheets that are in the same workbook.

$$Excel-Macros$$ VBA help

I have made this code for I have two worksheets that are in the same workbook. I want to check the values of WS 2, Column B to WS 1, Column B. If there is a match, then copy/write the row of WS1 to WS 2. but in my code I am retreiving the values through cells one by one I want *if cell

Re: $$Excel-Macros$$ VBA help

Dear Pavan, Please use.. Sub Close_excelApplication() Application.Quit End Sub -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 3:18 PM, Pavan Chowdary pavansai.vall...@gmail.comwrote: Hi, This is pavan. Here i had a

$$Excel-Macros$$ VBA Help

Hi, This is pavan. Here i had a doubt. is there any vba code to close whole excel application? if it there you please let me know by reply to this mail. Thanks, Pavan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ VBA Help

Hi Pavan Try Public Sub CloseAll() Dim WB As Workbook Application.DisplayAlerts = False For Each WB In Workbooks If Not WB.Name = ThisWorkbook.Name Then WB.Close SaveChanges:=False ' Or True if you want changes saved End If Next WB ThisWorkbook.Close SaveChanges:=False End Sub HTH Mahesh On

Re: $$Excel-Macros$$ VBA Help

Dear pavan, Apart of Mahesh code, You can use also below code to close all excel application even Thisworkbook also Sub Excel_Application_Close() Dim wb As Workbook For Each wb In ActiveWorkbook wb.Close Savechanges:=True Next Application.Quit End Sub On Thu, Mar 8, 2012 at 3:18 PM, pavan

Re: $$Excel-Macros$$ VBA Help

2012/3/9 NOORAIN ANSARI noorain.ans...@gmail.com Dear pavan, Apart of Mahesh code, You can use also below code to close all excel application even Thisworkbook also Sub Excel_Application_Close() Dim wb As Workbook For Each wb In ActiveWorkbook wb.Close Savechanges:=True Next

Re: $$Excel-Macros$$ VBA Help

This simple one liner leaves sub closewholeexcelapplication() application.quit end sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pavan chowdary Sent: Thursday, March 08, 2012 3:48 AM To: excel-macros Subject: $$Excel-Macros$$ VBA Help Hi, This is pavan

RE: $$Excel-Macros$$ vba help

[mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Friday, September 09, 2011 9:42 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vba help If you do it that way, you're going to skip some rows: first loop: i = 1, selects 1 to 200 i = i + 200 = 201 second loop

$$Excel-Macros$$ vba help

Hi Group, I have one excel sheet with 2000 records. i want to split those records. those 2000 records should copy into moresheets for ex: main sheet -- 2000 records; sheet1 -- 1 to 200 sheet2 -- 201 to 400 sheet3 -- 401 to 600 . . . sheet10 -- 1801 to 2000 thanks in advance regards,

Re: $$Excel-Macros$$ vba help

Sub breaksheet_data() For i = 1 To 2000 Sheets(1).Rows(i : i + 199).Copy Sheets.Add After:=Sheets(Sheets.Count) Cells(1, 1).Select ActiveSheet.Paste i = i + 200 Next End Sub On Fri, Sep 9, 2011 at 12:47 PM, naresh v naresh.veerabo...@gmail.comwrote: Hi Group, I have one excel

Re: $$Excel-Macros$$ vba help

as ever you can.” - John Wesley - From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, September 9, 2011 11:40:55 AM Subject: Re: $$Excel-Macros$$ vba help Sub breaksheet_data() For i

Re: $$Excel-Macros$$ VBA Help

You can use EDATE if using Excel 2007. Rest you can define in Macro. Regards, C.G.Kumar On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote: I'm a beginner with VBA and looking for some guidance in how to establish what I'm trying to do. Column A Column B

Re: $$Excel-Macros$$ VBA Help

refer attachment On Sat, Oct 23, 2010 at 9:35 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: You can use EDATE if using Excel 2007. Rest you can define in Macro. Regards, C.G.Kumar On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote: I'm a beginner with VBA

$$Excel-Macros$$ VBA Help

I'm a beginner with VBA and looking for some guidance in how to establish what I'm trying to do. Column A Column B Column C Column D 1/15/2010 6/30/2009 3/2/2010 4/15/2008 I'm trying to create a VBA formula that will do the following in columns C and D: Column C should just be one

$$Excel-Macros$$ VBA Help for comparing two lists

Dear All, I am having two lists, which contains trial balances. Every month one or two codes are getting added in the TB which i have to identify. Now to identify the new codes we use vlookup function on both the sheets and where #N/A Error comes we come to know that these are the newly added

Re: $$Excel-Macros$$ VBA Help

Hello Dear, You can bind the uses of VBA for specific industry.I am working with mainframe and we have to record the jcl log,We send all jcl log to the VBA Admin to arrange it date/time wise according to time. but my others friend are working in Other domain,told me that vba is also important

$$Excel-Macros$$ VBA Help

Option Explicit Sub InputSales() Dim MonthOfSales As String Dim SalesData(1 to 4) MonthOfSales = InputBox(prompt:= Enter month of sales, _ title:= Month) SalesData(1) =InputBox(prompt:= Enter sales for week 1) SalesData(2) =InputBox(prompt:= Enter sales for week 2)

Re: $$Excel-Macros$$ VBA Help

to uppercase and puts it in Cell A1. P From: Shiv Goel shivyn...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, February 11, 2010 2:34:06 AM Subject: $$Excel-Macros$$ VBA Help Option Explicit Sub InputSales() Dim MonthOfSales As String Dim

$$Excel-Macros$$ VBA Help

Hi Everybody, i want to know which industry use VBA for excel programming most.? So that i can apply for jobs who does VBA excel programming and also suggest me the links or websites to apply jobs for VBA excel programming. Thanks in advance. Regards, Chethan --