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,489 Posts: 590,035
106,489 590,035
Excel VBA / Macros (2,805/15,330)
Excel Formulas (478/2,448)
Excel General (103,027/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,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,378
976 6,378
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (482/3,884)
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 2433 users online. 8 members and 2425 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 120,503   Posts: 658,636   Members: 310,546   Active Members: 872
Welcome to our newest member, tpv0608.

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


  • 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.

    3 hours 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
    7 hours ago
  • Summer7Sun
    How to update values real time of a work sheet which is shared on network drive
    Hello Friends

    I have 2 workbooks and both workbooks have a macro which I have to run when they are opened and those macro have to keep running and to my understanding i cant run them at the same time on the same system. ( If I can run different macros on different workbook on same system then how or may be same workbook different sheets )

    Workbook 1 and Workbook 2 are in a shared drive which i can access from another System
    workbook 1 will only run if some values are updated from workbook 2(work book 2 has some values and workbook 1 is linked to those values.

    My problem is the values dont update on real time back to workbook 1 on real time bases the values update only after the workbook is saved and closed .... Please help...
    11 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....
    2 days ago

Trending on OzGrid


  • Furybringerx
    Parsing HTML Table to Excel
    My personal project this past week has been trying to parse a HTML table to Excel.
    I've used many resources to finally get the code I'm looking for. It has taken a week to figure it out so I feel that I should share it to help others like me.

    Sub ParseTable()
    Dim IE As InternetExplorer
    Dim htmldoc As MSHTML.IHTMLDocument 'Document object
    Dim eleColtr As MSHTML.IHTMLElementCollection 'Element collection for tr tags
    Dim eleColtd As MSHTML.IHTMLElementCollection 'Element collection for td tags
    Dim eleRow As MSHTML.IHTMLElement 'Row elements
    Dim eleCol As MSHTML.IHTMLElement 'Column elements
    Dim ieURL As String 'URL
    'Open InternetExplorer
    Set IE = CreateObject("InternetExplorer.Application")
    December 11th, 2013, 05:39
  • 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
  • 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