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,972 Posts: 592,183
106,972 592,183
Excel VBA / Macros (3,151/16,894)
Excel Formulas (571/2,943)
Excel General (103,057/572,076)
Excel FAQ (165/175)
Code Review (10/45)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,385 Posts: 16,087
1,385 16,087
Topics: 6,425 Posts: 28,409
6,425 28,409
Excel and/or Word Help (1,248/5,211)
Excel and/or Access Help (2,600/11,465)
Excel and/or Email Help (1,265/5,462)
Excel and/or SQL Help (821/3,816)
No questions in this forum please.
Topics: 594 Posts: 2,402
594 2,402
Topics: 981 Posts: 6,437
Last Post: Word Play
981 6,437
Word Play
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (486/3,943)
Test Area (460/2,380)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 18 Posts: 20
18 20
Free Excel Templates
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 5448 users online. 22 members and 5426 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 121,038   Posts: 661,276   Members: 311,485   Active Members: 524
Welcome to our newest member, mrbeasled.

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


  • James123456
    Filled Map Chart Series Color

    I have a filled map inserted into a worksheet. I am trying to change the series colour within this map for Minimum, Midpoint and Maximum to Red, Blue and Green respectively through VBA but having no luck. It is a Diverging series (3 colour).

    The code below is supposed to change the colour but it doesnt, any ideas what could be wrong or any other way of doing this? I am using Office 365.

    ActiveSheet.ChartObjects("Chart 3").Activate
        ActiveChart.FullSeriesCollection(1).GeoMappingLevel = xlGeoMappingLevelWorld
        ActiveChart.FullSeriesCollection(1).SeriesColorGradientStyle = _
    With ActiveChart.FullSeriesCollection(1)
    5 minutes ago
  • Tyrion08
    USD 25 Negotiable - Run through multiple data-sets and create a variance report
    Hi All,

    I have a requirement where I want to build a small utility that runs through multiple data-sets and builds a variance report.

    I am working on creating dummy data as I want to mask the real data - this should be done shortly.

    The amount quoted for this work is of course my estimate. But fair to say that I will let whoever picks it up name a fair price based upon the complexity of the requirement ( I trust you guys to come up with a fair number based upon your past experience).

    I will email all dummy data and detailed requirements to whoever is interested to take it up.

    PS: 10% paid to ozgrid already.

    12 minutes ago
  • Sp0ns
    Sum average networkdays if cells aren't empty

    Column G4:G503 all contain a start date
    Column H4:H503 all contain an end date

    What formula could I use to calculate the average difference between all these dates ?

    works for the first cell but this needs to be done over all forementioned cells without using a helper column
    It should also need to check first for empty values; if one of the dates isn't filled in, there should be no result

    Thanks in advance,

    56 minutes ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • chirayuw
    Word Play
    Aim of game is very simple

    Say the first word that comes into your mind after seeing the last word posted in the thread

    To start - Eye
    January 27th, 2014, 19:24
  • XCage
    Combo box dependent on Option Buttons
    Hi Everyone

    I am relatively new to VBA.
    I have an User form that will be designed to create a quote. It has multiple sheets in the background. The user will select the various options for the project.
    I am struggling to create the form so that when they select option button 1 then the combo box populates with certain data, when the select combo box 2 it populates with other data etc...
    Thinking If statement would be the best..

    If OptionButton1 = True Then

    Can anyone guide me in the right direction?
    September 14th, 2017, 15:51
  • pulsar777
    Cdo smtp - combine textbody with htmlbody

    a sample email message would look like :

        With eMessage
            .To = "[email protected]"
            .From = """Incredible Hulk"" <[email protected]>"
            .Subject = "Body Splash"
            .TextBody = "Roaaarrr"
            .CreateMHTMLBody "file:///C:/Users/Winner/Desktop/signature.html"
        End With
    So I would like to combine a text message (TextBody) with an HTML document which would be a signature.
    How to do it without modifying html file ?

    Thanks !
    1 week ago
  • iwrk4dedpr
    Determining / Reading Serial Communications.
    OK. So I've finally figured out how to read a com port with vba+

    How to Read Com port I can post my code below ... It works, however, you need something going over the com port or you can't use this. What I'm doing is an Arduino project that sends data back over the serial port ( com4 in this case ) and its output is below the code.

    What I need to know. Is how do I figure out the number of bytes to get from the port ( it's set from the example @ 64 ) from the displayed output how do I decide how many to get. OR better .... how do I "watch" the com port and have it tell me it has msg ready.

    I'll just attach the workbook instead of code!

    The following is the output from the arduino!
    6 days ago
  • Proibido23
    Copy/Paste Loop
    Hi, i very much appreciate guidance on the following. On a worksheet i have the following range named "Stock_List"

    A1 = "SP"
    A2 = "XOM"
    A3 = "FB"
    A4 = "APPL"
    A5 = "DJIA"

    Currently in my input cell Q1 (which is a named cell "Ticker_Input") i manually cycle through "SP" then replace with "XOM" then replace with "FB" then replace with "APPL" and then replace with "DJIA" to run various scenarios in an excel model

    I would like a macro that will automate this process, so rather than me doing it manually 1 by 1, the macro will do it automatically. My actual "Stock_List" range is A1:A500

    4 days ago