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,875 Posts: 595,684
107,875 595,684
Excel VBA / Macros (3,834/19,513)
Excel Formulas (703/3,506)
Excel General (103,126/572,344)
Excel FAQ (165/175)
Code Review (14/55)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,409 Posts: 16,273
1,409 16,273
Topics: 6,441 Posts: 28,445
6,441 28,445
Excel and/or Word Help (1,251/5,216)
Excel and/or Access Help (2,603/11,473)
Excel and/or Email Help (1,267/5,468)
Excel and/or SQL Help (822/3,817)
No questions in this forum please.
Topics: 595 Posts: 2,407
595 2,407
Topics: 989 Posts: 6,517
Last Post: Excel 2016
989 6,517
Excel 2016
by KiM91
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (492/4,020)
Test Area (460/2,381)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 19 Posts: 22
Last Post: Merge Outlook data
19 22
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 4737 users online. 26 members and 4711 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 122,004   Posts: 665,283   Members: 313,262   Active Members: 648
Welcome to our newest member, gmcmilla.

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


  • summermurray
    Macros provoked a problem
    I have been creating excel document during a week, but when I added a macros to it, only after 20 minutes Excel 2010 was closed. I opened it again, but I saw Excel found unreadable content in Job_21.xlsx. I applied repair excel file software from Microsoft, but it didn't nothing. Then I tried to open it on another version of Excel, but the same negative result. And now I have only one question, is it possible to see my data again?
    1 hour ago
  • Regina Falange
    From Excel sheet to VBA Form to Excel sheet - HELP!
    Regina Falange
    Hi Everyone,

    New to the forum so sorry if I post anything incorrectly!

    Also very new to VBA...

    So I have created a VBA form with 3 parts to it.

    First part is to perform a search on an excel sheet - two requirements are added from a dropdown menu on the VBA form which should act as a filter to search on the excel spread sheets. So I have Criteria A (which are initials that can be found on the spread sheet also), then I have Criteria B which is the status which can also be found on the excel sheet. Then I have an Assign button and Save button and a Next button.

    Example: Name: AA // Status: Pending > click search button. >> This should pull through the information on the spread sheet that meets those requirements....
    3 hours ago
  • Nick Leow
    Auto copy range data and paste on last empty row
    Nick Leow
    I'm new to VBA and trying to auto copy and paste a range of data from daily production file(2018-05-23.xlsm & 2018-05-24.xlsm) and paste on a master file(Master-3.xlsm) by clicking the "CommandButton1" inside worksheet name "Summary" in Master-3.xlsm.

    The VBA code will refer to "C1" value in "Summary" for which file I want to copy so that I can just changing the file name to auto copy the daily production data into Master-3.xlsm. The code will perform autocopy data A490:AJ510 for every sheets inside daily production file into Master-3.xlsm which has the same sheet names.

    The problem I'm having:
    1) I want to copy rows that have value(ignore formula) until blank row on A490:AJ510 inside every sheet of daily production...
    10 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • 7absinth
    Macro that extract video filename, size and duration and list to Excel
    I wonder if there is any macro that find and list video filenames, size and duration. I cant find best macro that match to this criterias so maybe somebody has written this code yet.
    September 17th, 2015, 22:22
  • DiogoCuba
    Concatenate results

    I need some help on gathering information to present on a report.

    This file tracks issues, they are all numbered and they are also classified (A, B, C, D, M, NA). Also they have status and here is the problem I am trying to fix:

    This formula to return values of the number of issues that meets a certain status and class:

    Any issue classified as "B" and with status Waiting to Be Cleared then it would return: "Issues 129 and 300 are waiting to be cleared", where 129 and 300 would be the result of the formula I cannot find.The rets is discarded.

    The attached file can show you better....
    November 27th, 2017, 06:38
  • Shezmo1
    look for value in three different ranges and return one of three results.
    Hello all,

    First I would like to apologise for the awful way I am going to explain this but what I would like to do is use a formula to compare a cell against a range and then return the value from another cell. Iíve included a screenshot of a sample of data and hope this helps with me explaining. I would like a formula that goes into cell A5 which looks at the value in cell B5 and looks it up in one of the columns (either I4:I6, K4:K5, M4:M6) Depending on which range it is found in it then returns the value in either I3, K3 or M3.

    Or if it makes it easier have the list of users with the location next to them (second screenshot) so it would look at column B for the value checked the range of I5:I12 and then return the location from the cell to the left.
    1 week ago
  • harsha6989
    Vba to change colors in a variable cells
    Hi all, I need a help as inserted in picture/excel sheet we will have variable cells matrix.The attached is 23 X 23 and its variable. I need a macro for this like a kind of a button when clicked
    1. Only 2 color box has to present in each rows and columns.
    2. Coloring should spread through out the matrix.
    3.Coloring should vary each time when we click the button....
    1 week ago
  • CDX
    Excel 2016 prompt for external data filename on workbook open

    I'am new to Excel VBA and macros, so keep calm if I don't first understand

    I'm using Excel 2016.

    I have made an Excel workbook with Power Query imported csv-data from csv-file, excluding few lines from start and end of the file, and reformatted data values.

    This is one file I have, and it works perfectly.

    Now I want to make another file with one exception. When opening workbook, Excel asks for external data file. And when opening that file, it imports just as like the other workbook.

    There was on older versions of Excel an option to "prompt for filename on refresh" but not in the new version.

    Ask if you need more information, I try my best to answer.

    I really appreciate...
    1 week ago