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 = Sheet1.Cells(Rows.Count, 1).E
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
Ra
Great!!
ᐧ
On Tue, Jan 20, 2015 at 6:34 PM, sach so 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:
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 >
> wrote:
>
>> Dear Expert,
>>
>> I required some changes in VBA
Sach,
Amended code to suits your need..
Cheers!!
On Fri, Jan 16, 2015 at 5:28 PM, sach so 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 output.
>
> *
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
wrote:
> I have made this code for I have two worksheets that are in the same
> workbook.
>
> I want to check
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
wrote:
> Hi,
>
> This is pavan.
> Here i had a doubt. is there any vba co
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.
2012/3/9 NOORAIN ANSARI
> 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
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 chowd
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 Thu
[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
long as ever you can.” - John Wesley
-
From: ashish koul
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 = 1 To 2000
She
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 wrote:
> Hi Group,
>
>I have one excel sheet with 2000 records.
refer attachment
On Sat, Oct 23, 2010 at 9:35 AM, C.G.Kumar wrote:
> 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 wrote:
>
>> I'm a beginner with VBA and looking for some guidance in how to
>>
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 wrote:
> 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/
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 for
Hi Chethan,
Finance, Consulting - Analytics industries (KPO-BPO) uses VBA most, and I
would suggest you to update your resume in some top job portals and then
you'll automatic receive job opportunities.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dil
Shiv,
Are you not using Excel help?
or are you reading a book and trying to understand it?
Or are you in school and this is your homework?
Option Explicit Statement
Used at module level to force explicit declaration of all variables in that
module.
Syntax
Option Explicit
Remarks
If used, the
19 matches
Mail list logo
