No announcement yet.


  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
No content found
Show More
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
Please log in to your account to view your subscribed posts.
Directory Topics Posts Last Post
Pick the APPROPRIATE category below to post your question and/or answer questions.
Topics: 106,478 Posts: 589,986
106,478 589,986
Excel VBA / Macros (2,798/15,296)
Excel Formulas (477/2,444)
Excel General (103,024/572,024)
Excel FAQ (165/175)
Code Review (8/41)
PLEASE PAY (via PayPal) 10% of your cost to [email protected] BEFORE you post. Then pay the remaining 90% to the person who completes the job on completion.
Topics: 1,372 Posts: 15,971
1,372 15,971
Topics: 6,408 Posts: 28,368
6,408 28,368
Excel and/or Word Help (1,245/5,197)
Excel and/or Access Help (2,598/11,463)
Excel and/or Email Help (1,261/5,453)
Excel and/or SQL Help (820/3,814)
No questions in this forum please.
Topics: 592 Posts: 2,384
592 2,384
Topics: 974 Posts: 6,368
Last Post: Word Play
974 6,368
Word Play
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (481/3,875)
Test Area (458/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 18 Posts: 20
18 20
Newsletters (0/0)
Excel Blogs (0/0)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (0/0)

What's Going On & Who's Online?


There are currently 1673 users online. 13 members and 1660 guests.

Most users ever online was 13,741 at 02:14 on February 3rd, 2012.

Free Excel\VBA Help Forum Statistics


Topics: 120,489   Posts: 658,574   Members: 310,536   Active Members: 978
Welcome to our newest member, Miyoshi.

Welcome to OzGrid!


Welcome to the community! Please take a moment to:

and if you have any questions - drop by in the HAV A CHAT forum!

Latest Topics


  • yzhang316
    Excel VBA Macro Filter Selection Issue
    Hi, I am tyring to create filter selection process using VBA macro, but for some reason, the value from a filtered field is not working. Please take a look at my code..

    Sub Step3Pivot()
    Dim pt As PivotTable
    Dim pf As PivotField
    Dim Pi As PivotItem
    Set pt = ActiveSheet.PivotTables("NetZero")
    Set pf = pt.PivotFields("GL_xxxx")
    pf.Orientation = xlPageField
    Set pf = pt.PivotFields("CODE_xxx")
    pf.Orientation = xlPageField
    Set pf = pt.PivotFields("PA_NUM_xxx")
    pf.Orientation = xlRowField
    Set pf = pt.PivotFields("PA_PRO_xxx")
    pf.Orientation = xlRowField
    Set pf = pt.PivotFields("PA_TASK_xxx")
    pf.Orientation = xlRowField
    14 hours ago
  • SirStumpedALot
    VBA Textbox Value Returned from Array Formula
    Hello there,

    First time posting on one of these sites, but I just can't seem to find what I am looking for.

    Essentially, I have a userform with three boxes that I would like to act as a search area. This userform will require two inputs, and the result will show in the third box. Picture of the userform is attached.

    So, the first textbox is an input where you would enter a part number. The second box is a combo to select items from a dynamically named range.

    What I am trying to do is have the third box (text) show the result of the search based on the first two boxes, and this is the formula I am trying to make work:

    Private Sub CommandButton1_Click()
    TextBox3.FormulaArray = "=INDEX(WTB!$C$2:$C$383778,MATCH(1,(textbox1.value=WTB!$B$2:$B$383778)*(combobox1.value=WTB!$A$2:$A$383778),0))"
    18 hours ago
  • neildeilyo
    Filtering on multiple criteria not working
    I have the following code, which I would like to expand. I would like the data to be filtered down to anything that starts with the letter F in column 113 and certain things that start with the letter V. I would like to expand upon this, to include a list of about 23 allowable criteria that start with V, but I am already running into roadblocks.

    Any clue how to solve this?

    Sub filter2()
    Dim Lastrow As Long
    Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
    With ActiveSheet.Range("A1:EN" & Lastrow)
    If ActiveSheet.FilterMode Then .AutoFilter
    .AutoFilter Field:=113, Criteria1:=Array("F***"), Operator:=xlOr, Criteria2:=Array("VMMA", "VMMB", "VMMC, "VMME")
    18 hours ago

Recent Blog Posts


  • Raina
    The Wizard of Oz
    As most of the Excel/VBA community are aware, Dave Hawley – founder of OzGrid passed away from a rare brain disease in June 2013. Dave and I ran OzGrid together, and I have been active on the Forum under Dave’s account since his passing. With the Forum upgrade now complete, it is the appropriate time for Dave’s Forum account to be retired with the very fitting title of the Wizard of Oz.

    I will continue to administer the forum as the owner of OzGrid, and can be contacted through the forum if required. Dave will always be remembered as the founder of OzGrid and the huge contribution he made to the Excel/VBA community. Long live Dave’s memory as the Wizard of Oz....
    13 hours ago

Trending on OzGrid


  • Erik PLS
    Hide entire row based on value of one cell
    Erik PLS
    Hi, I am new to Ozgrid and registered because I have already found many helpfull forum threads here.
    Now I have a thing on my mind I can't seem to fix:

    I am not completely unknown to programming, but most is learned by trial and error, and a lot of internet searches.

    I have a semi dynamic orderform which is used for several departments in our company.

    With formulas in the excell form I give a preset value to each cell in column M; value will be V or D (Visa or Dölj/View or hiDe) I can change this to any other value of course.

    I want to hide every row of which cell in column M has value D, and view every row of which cell in column M has value V.
    After excesive searched over via Google I have found several simular problems, but...
    August 28th, 2017, 20:31
  • brajpalshishodi
    Run Time Error 1004 - Autofilter method of Range Class failed
    Hello Guys!

    I am facing an usual problem in the form of Run Time Error 1004: Autofilter method of Range Class failed. Below is my code and this error is occurring on Srng.AutoFilter Field:=2, Criteria1:="=*Express*", Operator:=xlAnd
    It was working fine as of now but when workbook open for the first time, it throws this error, so kindly look into it and let me know how can it be rectified.

    Sub Sort_With_Express()
    Dim wbNam As String, ws As Worksheet, lr As Long, Srng As Range, Frng As Range
    wbNam = ActiveWorkbook.Name
    Set ws = Workbooks(wbNam).Worksheets("7-Non US")
    lr = ws.Range("A" & Rows.Count).End(xlUp).Row
    Set Srng = ws.Range("A1:R"
    September 4th, 2017, 18:55
  • Pratibha
    Choose either number
    Is there any formula in excel where the function chooses or selects any of the three numbers 10 or 100 or 1000 randomly and not any other number.
    But only these three numbers should be chosen at random either 10 or 100 or 1000 and every time I reset the chosen number should change.
    For eg if one time it it chooses 10 next time it should be either 100 or 1000
    September 4th, 2017, 20:07
  • legin52
    Variable number of rows of data
    I am hoping somebody can help me as my knowledge and logic have been exhausted.

    I have a workbook with 2 sheets in it.
    ‘Printer Macro’ from here known as ‘1’
    ‘Printer Header Sheet’ from here known as ‘2’

    A set of data is imported to ‘1’. It occupies columns A to L
    However the number of rows occupied changes each time the project is run and it is this that is causing me problems.
    What I am trying to achieve is:
    Step1: Select A:L from row 1. Copy the data. Go to ‘2’ and paste (values and format) into cell A2 of this sheet. Then print sheet ‘2’.
    Step 2: Repeat Step 1 but with Row 2 (A:L from ‘1’). Then paste into the same cell as step 1 (i.e. A2 of sheet ‘2’). Then print sheet ‘2’
    This repeats for...
    September 14th, 2017, 03:09
  • dorian777
    Linking to externat data from Excel online
    I wonder if it is possible to connect to ANY data source from an EMBEDDED excel workbook (original is stored in one drive)?

    I tried setting up a WEB QUERY in desktop excel and then online excel says it does NOT SUPPORT WEB also say IT DOES NOT SUPPORT LINKS TO EXTERNAL WORKBOOKS....

    BUt it has the option to refresh connections....what are they??????

    Do you know?
    4 weeks ago