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: 109,012 Posts: 601,081
109,012 601,081
Excel VBA / Macros (4,661/23,507)
Excel Formulas (858/4,295)
Excel General (103,259/572,910)
Excel FAQ (165/175)
Code Review (18/70)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,441 Posts: 16,506
1,441 16,506
Topics: 6,454 Posts: 28,467
6,454 28,467
Excel and/or Word Help (1,257/5,225)
Excel and/or Access Help (2,603/11,475)
Excel and/or Email Help (1,269/5,466)
Excel and/or SQL Help (824/3,825)
No questions in this forum please.
Topics: 597 Posts: 2,417
597 2,417
Topics: 989 Posts: 6,548
Last Post: Word Play
989 6,548
Word Play
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (500/4,061)
Test Area (459/2,378)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 18 Posts: 20
Last Post: Knitting patterns
18 20
Knitting patterns
by Carim
Newsletters (0/0)
Excel Blogs (0/0)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (1/2)

What's Going On & Who's Online?


There are currently 3759 users online. 20 members and 3739 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 123,195   Posts: 671,109   Members: 315,506   Active Members: 663
Welcome to our newest member, chamarnadh.

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


    Body does not appear when sending outlook mails with signature with excel macro
    Since I am new to the VBA I am trying to structure a code to send email through outlook with the signature.But when I run the below code it displays me only the signature(body does not appear).

    When I use "F8" and check it can be clearly seen that my body appears then signature overwrites it.I tried with a lot of experts' answers but it remains with only the signature or only the body.How do I fix this?

    Option Explicit  Sub SendEmailwithsign()  Dim objoutApp As Object, objoutmail As Object Dim strbody As String, strSig As String Set objoutApp = CreateObject("outlook.Application") Set objoutmail = objoutApp.CreateItem(0)  On Error Resume Next  With objoutmail    .To = "[email protected]"   .CC = ""   .Subject = "Test mail"
    2 hours ago
  • SteveSchroder
    Counting the number of entries that fall within a specific month
    Good afternoon

    I am hoping someone will be able to help me with this little problem.
    I have a spreadsheet that i track health and safety data for some of my clients. I am setting up a reporting dashboard and one of the things that i would like to do is return how many lost time injuries and medically treated injuries have occurred within a specific month. based on if they are a contractor or not. However, i have not been able to get this to work.

    I have used the following tow formulas with little success
    =COUNTIFS(Table3[Date of incident];"="&MONTH(Reporting!C13);Table3[Date of incident];"="&YEAR(C13);'Incident Register'!C6:C13;"Yes"
    =SUM(IF(MONTH(Table3[Date of incident])=MONTH(Reporting!D13);IF(YEAR(Table3[Date...
    5 hours ago
  • tyneexi
    CountA .. If then Else Statement not working
    Good Day Experts,

    i really had a hard time deciphering whats wrong with this code: my txtrecno.value = 2 in cell B2 but the if statement will still skip my procedure..please help..thank you

     Private Sub CommandButton1_Click()
    Dim eRow As Integer
    Dim x As Integer
    Set WS = Worksheets("TimeSheet")
        With WS
            If Me.TXTRECNO.Text = "" Or Me.TXTHRS.Text = "" Then
               MsgBox "Please Select Job Order to Save.", vbCritical, "Alert"
                eRow = Application.WorksheetFunction.CountA(Sheets("TimeSheet").Range("B:B"))
                MsgBox " erow is " & eRow
    5 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • Dave Hawley
    Importing mail accounts from Live Mail to Outlook 2007
    Dave Hawley
    Importing mail accounts from Live Mail to Outlook 2007

    After a clean install of Windows 7, I installed Office 2007, which I already used with Vista. I also installed Windows Live Mail, not to use it as an e-mail client, but only as an intermediate to import mail accounts, as I used to do with Outlook Express on XP and later with Windows Mail on Vista; Outlook 2003 and 2007 do not import e-mail accounts files. Therefore, I imported all my many e-mail accounts settings to Windows Live Mail from previously saved IAF files.

    Until here all worked as expected. The problem is that now, when I try to "Import internet mail account settings" from Windows Live Mail to Outlook it just answers "No internet accounts were found to import"....
    November 16th, 2009, 18:11
  • 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
  • RussSidney
    Merge column based on condition
    If column Stack is more than 1, merge the data on Color, Stack and size on the row and the rows below depending on the value eg. if stack value is 4, the data on Color, Stack and Size column on that row and the next 3 rows will merged together except for Row column.

    Thanks in advance....
    4 weeks ago
  • engineer427
    VBA Calculate Sheet Not Working on MAC
    I have code written that searches and pulls data from another worksheet when you click a button. There is a 3 letter code that also pulls up a picture that corresponds to that code. I have not written that into my VBA. Instead I have defined a name range and linked pictures. It works great when I type in the 3 letters manually. When I use the button to run the code and search for the 3 letters it will not update my picture. I have to click the "Calculate Now" or "Calculate Sheet" buttons after I click my button in order for it to change the picture. I have added the worksheet.calculate at the end of my VBA code to hopefully do this for me, but it still does not work. Here is a look at my code if anyone has any ideas:

    Sub findtruckinfo()
    Dim truckid
    1 week ago
  • jl2509
    Message if exists
    Hi All,

    On my worksheet, Range A2:A50 has data then a group number A, B, or C in column B
    using vba, how can I lookup the range A2:A50 to ensure A is shown a minimum of 10 times, and either B or C is shown a minmum of once.

    A message box to say "Selections Complete" if the criteria is met, or "Selections do not meeet requirements" if not.

    1 week ago