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,482 Posts: 590,002
106,482 590,002
Excel VBA / Macros (2,801/15,316)
Excel Formulas (477/2,444)
Excel General (103,025/572,026)
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,373 Posts: 15,976
1,373 15,976
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: 976 Posts: 6,372
976 6,372
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (482/3,878)
Test Area (459/2,380)
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 2307 users online. 16 members and 2291 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 120,496   Posts: 658,596   Members: 310,541   Active Members: 914
Welcome to our newest member, Quixtar.

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


  • Logit
    Not Seeing As Many Posts ???
    Since the upgrade to new platform, I'm not seeing as much participation as was previously. Every time I come to OzGrid there seems to be only 15 or 16 posts and a percentage of those are old.

    I've looked through everything I can find on the site to determine if I am 'searching' / 'selecting' / 'viewing' the FORUM correctly and have not found anything to indicate my method is in error.

    Have I missed something about viewing posts since the upgrade ? Has participation really dropped that much ? Or ... what am I doing wrong to view the activity ?
    7 hours ago
  • n1xn1x
    Unreliable Web Scraper Code
    I have a list of movie titles in excel and I've written a program that looks up each movie (on, and then scrapes a bunch of data for each title in excel. My code works just fine when I step through it manually, but when I run it automatically it doesn't work reliably. I cannot understand why this is. any ideas would be very much appreciated!

    For simplicities sake, we can assume the first 10 movies in my spreadsheet are ...
    10 hours ago
    MultiSelect List on User Form - Bring to view on "Search" Command
    My UserForm has a listbox with "MultiSelect" list items - I have coded them to Excel as a "String."
    However, the Command Search Button on the User Form will not bring up the items as previously "clicked" in the UserForm listbox. Does anybody know how to code this in the Command Search Button? Cheers.
    12 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....
    1 day 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