Posts by ashu1990

    Re: take value from 2 multi listboxes and search row for criteri

    try this

    Re: Excel instance will not close when using .Range().Sort in VBA

    if you are using api of excel from ms access then you have to close the instance of the excel api from the access itself hence you are not saving the excel file then it will not get closed as you want it to do

    i think the sorting code doesnt has any suspicious line of code as per me.

    Re: extracting data from web

    Hi Zohar,

    unable to understand what you want, post a link of the web page from which you have to extract data and the table or the section highlighted which you have to scrap.

    Re: Selecting a set of codes for Pivot table (Values) using VBA

    hope this helps

    Re: Control Tab Colors

    it is possible but you have to define all colore which you dont have to use and save it in an excel sheet and then retrieve data from there


    Sub test()
    Dim sh As Worksheet
    For Each sh In ActiveWorkbook.Worksheets
    If sh.Tab.Color = "Your Color" Then
    ''Do your stuff
    End If
    Next sh
    End Sub

    Re: Close Worksheet Event

    use this in thisworkbook module

    Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
        MsgBox Prompt:="You just left sheet:" & Sh.Name
    End Sub

    Re: Create A summary Page

    is the total row has sum of the aged columns if yes try this