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,492 Posts: 590,066
106,492 590,066
Excel VBA / Macros (2,807/15,357)
Excel Formulas (479/2,450)
Excel General (103,027/572,037)
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,978
1,373 15,978
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,388
Last Post: Word Play
976 6,388
Word Play
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (482/3,894)
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 2866 users online. 9 members and 2857 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 120,508   Posts: 658,689   Members: 310,547   Active Members: 812
Welcome to our newest member, farijsvanjava.

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


  • luzmen
    Get Column Number in a given range

    I have some difficulty in solving a formula for COLUMNS. I want to get the equivalent number for the last column in a given range.

    This is my table looks like:
    A B C
    Column where to Start Column where to End Formula to get the number of End columns
    G I
    I know the formula is =COLUMNS(G:I) and the result is 3. How do i write the COLUMNS formula that instead of typing G:I, it will locate the stated value in column...
    17 hours ago
  • dgraham62
    Use VBA to select current cells and then select down a variable number of cells

    I'm having trouble attempting to use VBA to select cells.

    I have 7 cells selected in row 4, what I need to do is keep those cells selected and also select down a number of rows (the number can change) to copy the cells in row 4. Any assistance is appreciated.

    1 day ago
  • tpv0608
    Apply Script to More than One Column
    This is my first post to the forum, but I have been an observer for quite a while. I am fairly new to VBA in excel and have run into a problem I am not sure how to resolve.

    Private Sub Worksheet_Change(ByVal Target As Range)
    'Color cells based on Selection
    If Target.Address = "$C$10" Then
    Application.EnableEvents = False
    If Range("C10").Value = "COVERAGE" Then
        Range("C19:C23").Interior.ColorIndex = xlColorIndexNone 'Highlight Cells
        Range("C19:C23").Interior.ColorIndex = 15 'Highlight cells
        Range("C19:C23").ClearContents  ' Clears Item
        Range("C40:C45").Interior.ColorIndex = xlColorIndexNone 'Highlight Cells
    1 day 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....
    3 days ago

Trending on OzGrid


  • 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
  • Bryan021
    Cell not retaining font size format
    I have a cell at the bottom of the page with some fine print verbiage that is all formatted as Calibri 7, with some characters Bold.
    It appears correct onscreen, and prints correctly... I save the file and it still looks good, but if I close and reopen the file, the font returns to an 11 size, but retains the font type and bold... this pushes the end of the line off the page.
    Any idea what's going on with this?
    Your input is appreciated.
    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....
    5 days ago
  • Beard gu brath
    VBA to change the format of a range of cells based on dates.
    Beard gu brath

    I am currently attempting to make a calendar function for a manager in my office. She would like it so that when when staff input their time off that is formats a overall calendar view to show when they are off. with each member of staff down the left and the dates shown across the top.

    I had thought to loop through all the names on the employee tracker list to filter and amend the cells but I am having trouble making it work, I will post what I have been trying below. I apologise for the mess, i am still getting to grips with VBA. On the "2017" sheet I have put the dates adjacent to each person.

    Sub Edit2017()
    Dim rng As Range
    Dim c As Range
    Dim x As Range
    Dim y As Range
    Dim myrow As Range
    Dim a As
    3 days ago
  • AlanSidman
    Testing upload of file -- no reply required.
    2 days ago