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: 107,436 Posts: 594,115
107,436 594,115
Excel VBA / Macros (3,508/18,397)
Excel Formulas (636/3,235)
Excel General (103,085/572,176)
Excel FAQ (165/175)
Code Review (14/55)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,392 Posts: 16,152
1,392 16,152
Topics: 6,433 Posts: 28,430
6,433 28,430
Excel and/or Word Help (1,249/5,213)
Excel and/or Access Help (2,602/11,472)
Excel and/or Email Help (1,265/5,464)
Excel and/or SQL Help (822/3,817)
No questions in this forum please.
Topics: 595 Posts: 2,405
595 2,405
Topics: 990 Posts: 6,465
990 6,465
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (494/3,970)
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 3983 users online. 18 members and 3965 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 121,539   Posts: 663,475   Members: 312,398   Active Members: 750
Welcome to our newest member, bella_gi.

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


  • Magdoulin
    Excel VBA to Generate Outlook Message with a Body from Word File
    Hi Guys,

    I am trying to write an VBA Code that would help creating Outlook Email message with To, CC and Subject fields.

    However, the body, I need to be read from Word File saved in my computer drive.

    Here is what I have reached so far, yet, it works only for creating the email message with the needed field except for the body part.

    Sub Email_Template1()
    Dim oMailItem As Object
    Dim oOLapp As Object
    Dim Word As Object
    Dim doc As Object
    Dim MsgTxt As String
    Set oOLapp = CreateObject("Outlook.Application")
    Set oMailItem = oOLapp.CreateItem(0)
    With oMailItem
    .To = "Email"
    .CC = "Email"
    .Subject = "Needed Confirmation"
    42 minutes ago
  • bella_gi
    Macro to copy and paste in the next empty row
    I have a range of rows and I want to copy the last range and paste to the next empty row.

    For example, in the attachment file, there is 3 set of data separate in three Sprints, anytime I want to add a newsprint I would like to copy the last sprint and add it to the next empty row. My idea is to create a macro to automate it through a button.

    Any idea how to do:

    This is my VB macro code:

    Sub NewSprint()
    ' NewSprint Macro
    ' including new sprint
    ' Keyboard Shortcut: Ctrl+Shift+M
    Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial (xlPasteAll)

    End Sub...
    1 hour ago
  • Jazper36
    Copy data from Multiple workbooks into One

    i want some help with VBA code.

    i have few workbooks & want to move the data from the different workbooks into one master file.

    the files are in different location & all have the same headers.

    i want to be able to copy the data & paste into the master without overlapping into the other data & also do a paste special while pasting it into the master file.

    Thank you for the assistants.
    1 hour ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • james40
    Hello all ! First post help with COUNTIF formula please ??
    Hi and thanks for any help it is truly appreciated !

    Ok so I am currently using a formula to count the number of cells in a range as below:

    Now my issue if that some cells with WOW as the value have an adjacent cell to the immediate left which is where the finish time would normally go and I would like to exclude these from the count, as they are counted in a different way.

    I've searched around and found some SUMIF examples but I'm struggling to get this to work !

    I know the over all count is ok as there is a discrepancy of 21 in 2 separate parts of the table which means 21 night shifts have been counted twice !
    2 weeks ago
  • NBVC
    Running Query refresh in VBA works in Excel 2013 but giving error in Excel 2010
    Hey guys,
    I am running an Excel query to my Sql Server database use vba to create the Select statement and refresh the query.
    I designed the workbook in Excel 2013 and it works well for anyone with Excel 2013 or later... but for some reason it is not running with Excel 2010.
    I am getting error: Automation Error -2147417848 The object invoked has disconnected from its clients

    when I click Debug it shows error at the .Refresh BackgroundQuery:=False statement

    This is the part of my code where I create and refresh the query....

    sConn = "ODBC;DRIVER=SQL Server;SERVER=Serv-M1;UID=MyLogin;pwd=MyPwd;Trusted_Connection=No;"
    sSql = " SELECT distinct Jobs.jmpPartID as 'Job Part ID',  Organizations.cmoOrganizationID as 'Customer ID', Organizations.cmoName
    1 week ago
  • weirax
    VBA If filtered table has any record, insert string

    I need your help to check what am I doing wrong.This is the table I am working on, called "ActionTable".

    What I want: filter for empty fields of status column with VBA code, and insert "NO ACTION STARTED YET" to Status and Letter column, plus the actual date to ADDED_ON column.
    The problem is, that if there is no record to show, the macro stops, even if I used an IF statement.

    The error message is "runtime error 1004. no cells were found"

    Can you please help me?
    6 days ago
  • mammes
    Save PDF copy of Validation List
    Hi all,

    First post - so apologies if I make a mistake.

    I'm a teacher and have created a spreadsheet that has a goal setting sheet with specific data for each student. Each student has a specific code which is used to identify them. I use this code to pull all the data from other sheets to create a Snapshot of each student. There is a validation list of codes in the top of the spreadsheet which allows me to cycle through students.

    What I want is for each individual student to have a pdf copy of their sheet only. I can't share the whole files with the students as it contains data about other students.

    At the moment I have been going through each student and saving as a pdf. The issue here as you can imagine is that it takes a while to do 300...
    4 days ago
  • stafford2
    An unknown error prevented access to Outlook
    Since I have updated Windows 10 on Lenovo Laptop, I cannot access MS Outlook. It just goes with an error message: An unknown error prevented access to Outlook

    Appreciate any help here!
    3 days ago