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,500 Posts: 590,105
106,500 590,105
Excel VBA / Macros (2,816/15,391)
Excel Formulas (480/2,457)
Excel General (103,025/572,035)
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,979
1,373 15,979
Topics: 6,409 Posts: 28,369
6,409 28,369
Excel and/or Word Help (1,245/5,197)
Excel and/or Access Help (2,599/11,464)
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,393
Last Post: Word Play
976 6,393
Word Play
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (482/3,899)
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 2465 users online. 8 members and 2457 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 120,517   Posts: 658,762   Members: 310,558   Active Members: 730
Welcome to our newest member, SoulDreamer.

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


  • Bambino86
    Deleting Rows Based on Values VBA

    I have a report that I would like automating in deleting rows if the value in B column is 0. How do I automate it? I have attached the file for reference. Since this is a recurring report that I format, I would like to store the code to my Personal.xlsb so that I don't need to store the code to a work book. thanks...
    2 hours ago
  • luzmen
    VLOOKUP from Multiple Workbooks with given reference range

    I have a main report worksheets that gets data from multiple workbooks thru VLOOKUP function. I don't have any problem with a formula, but in VBA code, i can't figure what to do.

    Attach are my sample files (in Zip Files coz it has 3 files). My sample files only have a little data but my real files have at least 1,000 rows per worksheets.

    Thanks in advance...
    4 hours ago
  • siva.apps123
    vba help

    I have workbook with many sheets. out of all i choose two sheets to print in a print preview format. for example sheet 1 and sheet 2 are the sheets i want to print preview . when i print my first page is sheet 1 with an footer (something like : page 1 header) and second sheet has data which is printed out as multiple pages. and footer from second page must be like :
    Total Number of Repairs to this point = 7 (count of entries in the page. i have braked the pages so that only seven entries are in each sheet. )
    Page: 2 of 146 ( since this is the second sheet and first page is header.).

    Now i have 2 issues.
    1) with the following code i am only able to print first page footer but not from the second sheet.

    Sub Print_Preview()...
    17 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....
    5 days ago

Trending on OzGrid


  • DiogoCuba
    US$20 to Automate Crew Roster
    Hi, I have a Crew Roster that controls the crew changes of a certain vessel and I would like to automate it to avoid wasting time with manual copy and paste.

    Anybody willing to help me?

    Some of the actions I need:
    • Create a Pax list and a Flight Manifest based on the personnel assigned to embark and disembark;
    • Generate a Daily POB based on the names that are onboard (Including the dates of embark and a counter to count how many days the person is onboard);
    • Compare the Daily POB to a criteria to see if the safe manning is compliant or not;
    • Create a PAX LIST for the next 7 days automatically so that I can see who is crew change and who is not - this should be triggered based on the dates;
    • Auto generate Flight Manifest when I click a button and input the
    June 27th, 2017, 09:47
  • nisaesin
    VBA Code to rename & saveas in the same file path

    I need a macro to "save as" my excel file with an extension to file name "_XS" in the same file path. For example, after I work on my file called "File1", I would like to run a macro that saves this file as "File1_XS" in the same folder.

    Many thanks for any help!
    4 weeks ago
  • sbox134
    Automatically fill cells with text based on values in two other cells
    I am new to VBA code, but have been able to figure out most of my issue through searching the forums. I've run into a pretty simple issue I can't figure out though.

    My end goal is to have cells D14 to D98 automatically fill with the text "Mfg Line" if cell D8 is "Product" AND Cell D9 is "Assembly". I would like this to happen as soon as the selections in D8 and D9 are made. If D8 is not "Product" or D9 is not "Assembly" I would like cells D14 to D98 to remain blank.

    I can't use an If formula in the cell because if the cell is blank the user will need to type in a value, which would delete the formula. It seems like it should be pretty simple, but I've tried piecing together information from other posts and haven't...
    2 weeks ago
  • darth_chunk
    Auto Hide Columns and/or Rows using VBA based on cell value (validation list)

    I'm wondering if anyone can help me with this VBA problem I'm having.

    To lay the backdrop; my understanding of VBA is limited and I've been reading tutorials to implement the functions I want. However, when trying to stack multiple 'If' arguments the code isn't behaving the way I expected it to.

    In short, I am using VBA to auto hide columns and or rows depending on the value of a cell which has a pre-determined list using a validation drop down box. The aim of this is to hide a range of columns, or multiple ranges of columns.

    So in the attached example, "SuperHero Patrol" when selecting 'Jan' from the drop down in Cell A1, I want the sheet to auto hide all columns where the date isn't January. When selecting 'Feb' it auto hides...
    1 week ago
  • mohammedismail
    Count Unique Values by category
    Hey Guys

    Can you please help me count unique values by Category. But the catch is if the product is already there in Batch1 it should not be counted in the Batch2. It should count only the unique values in Batch 2 which are not part of Batch 1 and 3. Same with Batch3.. the products must not repeat in Batch 1 or 2.

    Please find the sample sheet attached and also the desired output which I got using the pivot table....
    1 week ago