Question Tag: excel vba
Filter by
Filter by
Questions Per Page:
• ## How To Find Data Between Two Dates In Excel Vba ?

How To Find Data Between Two Dates In Excel Vba?

Expert Asked on June 18, 2017 in
• 163 views
• ## Email remittance advise to the vendors using outlook – excel vba

Hi I have a raw data which has to be sorted and for which i have given codes. Once the …

Participant Asked on October 12, 2017 in
• 108 views
• ## How to trigger my two marcos on any type of cell change in column E

Private Sub Worksheet_Change(ByVal Target As Range)                              …

Top Contributor Asked on October 30, 2017 in
• 98 views
• ## Adding and Subtracting Time

=IF(AND(ISBLANK(A4),ISBLANK(B4)),””,IF(B4=””,TO-A4+(TO<A4)*24,IF(B4<=”0″,B4-A4+(B4<A4)*24))) A4 = Driver Time In B4 = Manual over ride of a driver’s Time Out’ TO = A set …

Top Contributor Asked on October 31, 2017 in
• 93 views
• ## Good Morning! So I am apparently Stupid. VBA sort putting important data at bottom of sort

Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Worksheets(“Wednesday”).Range(“E4:E53”)   If Not Intersect(Xrg, Worksheets(“Wednesday”).Range(“E4:E53”)) Is Nothing Then   …

Top Contributor Asked on November 1, 2017 in
• 102 views
• ## Sorting using VBA

Private Sub Worksheet_Calculate() ‘On change to any cell in the range this code executes my copy macro Dim Xrg As …

Top Contributor Asked on November 15, 2017 in
• 117 views
• ## VBA EXCEL Sorting various sheets same workbook

Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Worksheets(“Monday”).Range(“F4:F50”) If Not Intersect(Xrg, Worksheets(“Monday”).Range(“F4:F50”)) Is Nothing Then Application.Run “DriverSchedule.xlsm!Sort1” …

Top Contributor Asked on November 20, 2017 in
• 117 views
• ## macros for excel 2016

Hi, Im having a macro for adding a new module into the excel. Aim is to insert this newly added …

Top Contributor Asked on December 7, 2017 in
• 102 views
• ## Delete Columns from Excel using VBA

Hi, I need to delete 2 adjacent columns which is placed somewhere in the middle of a table. So how …

Top Contributor Asked on December 13, 2017 in
• 117 views
• ## I need VBA Code to save my Pricing sheets of all four region’s customer’s files to be converted to Pdf and mailed to them. Help me!!

It’s like I got 4 folders (North, South,East, West) in a path and inside each region’s folder We got a folder …

Participant Asked on January 3, 2018 in
• 97 views
• ## Formula for finding the sum of alternate cells

Hi, I need to find a formula for finding the sum total of alternate cells(like C,E,F….) starting from column C …

Top Contributor Asked on January 16, 2018 in
• 83 views