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: 110,359 Posts: 607,441
110,359 607,441
Excel VBA / Macros (5,685/28,354)
Excel Formulas (1,040/5,166)
Excel General (103,366/573,367)
Excel FAQ (165/175)
Code Review (26/139)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,481 Posts: 16,866
1,481 16,866
Topics: 6,467 Posts: 28,494
6,467 28,494
Excel and/or Word Help (1,262/5,235)
Excel and/or Access Help (2,607/11,480)
Excel and/or Email Help (1,271/5,469)
Excel and/or SQL Help (825/3,830)
No questions in this forum please.
Topics: 598 Posts: 2,432
Last Post: VBA Merge sort
598 2,432
VBA Merge sort
by trunten
Topics: 994 Posts: 6,585
994 6,585
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (506/4,095)
Test Area (459/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 20 Posts: 22
20 22
VBA Replace text between brackets
Newsletters (0/0)
Excel Blogs (1/1)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (1/2)

What's Going On & Who's Online?


There are currently 4821 users online. 27 members and 4794 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 124,621   Posts: 678,111   Members: 318,182   Active Members: 521
Welcome to our newest member, Triplenick.

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


  • jlsprink
    $20 USD - Delete rows based off of multiple criteria - VBA.
    by jlsprink
    Hi All,

    Looking to delete rows in a spreadsheet based off of values that are present in three different columns.
    In layman's terms, here is what I'm trying to accomplish.

    If Column B does not have a value of "BONY01" and values in Column O = 0 and Column P = 0, then delete that row.

    In other words, I only want to view records of BONY01 that have a value other than 0 in either Column O or P or both. Everything else should be deleted.

    Spreadsheet may have several thousand rows.

    I've attached a spreadsheet with an original tab and a desired results tab for clarification as well.

    Sent 10% to Oz..... Transaction ID 4N645467MA471815X Thanks in advance for the assist....
    59 minutes ago
  • andrej
    data in one column
    by andrej

    I have data exported but get them in only in one column. There are 2 types of data (email and No of emails sent) and follow each other:
    [email protected]
    [email protected]
    [email protected]

    I would like to convert this convert into two columns, so that I can make table and later all kind of reports from this data. Any suggestion how I can easy transform this column in 2?
    2 hours ago
  • Persononfire
    Compile information from multiple sheets based on trigger word
    by Persononfire

    I apologize in advance if this has been asked before. I've found similar questions & results but based on different restrictions.

    I receive a file from another company that has multiple sheets with sets of information that are broken down into three categories per sheet. I need a way to compile all of the lines of information into one sheet, but only lines that are under a certain category, and to put the sheet name that the line is from in column A. Shoddy example file attached. So essentially, from every sheet, I would need to grab all the lines of information under "Category 2" up until, but not including, the header row and the row at the bottom of the category that has a "Total", slap it together in a single sheet, and add the sheet...
    2 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • kristisanchez
    I need help. I'd want to make a line graph/chart for my kittens to show their growth
    by kristisanchez
    First off thank you for even reading this.
    I really need some help and just can't figure it out.

    I want to show a growth chart of some of my animals over time using pounds and ounces, but can't figure out how to do it. I have tried to watch a bunch of videos and took an Excel class and still can't figure out how to do it. I am attaching some data from two of my animals and their weight. I don't know what to do next making the data decimals wont convert pounds to ounces correctly so I can put it in a double line graph with data points to show growth over time.

    If anyone is able to help me with a formula or showing me how to do this I would be really grateful.

    I copied my data to try a formula I found, but it didn't work...
    July 14th, 2019, 00:55
  • jmfloyd
    Word Macro not finding bookmarks IF they are inside textboxes
    by jmfloyd
    Hi there! Thank you for taking the time to read my question.

    I am working on a report generator in VBA that runs from a macro-enabled word document, and queries a macro-enabled excel workbook.

    I have managed to get values within specific cells to update bookmarks within the word document.

    However, I get errors that certain bookmarks cannot be found, but only the ones that are within text boxes.

    Here is my code:
    Public Sub RepGenWord()
        Dim oDoc As ThisDocument
        Dim xlApp As Excel.Application
        Dim xlSh As Excel.Workbook
        Dim FileToOpen As String
        Dim XAddress As String, XClient As String, XPhone As String, XEmail As String
        Set xlApp = CreateObject("Excel.Application")
    5 days ago
  • dilettante
    Changing function and argument descriptions
    by dilettante
    Ive written a macro that presents a Userform with three blank textboxes where the user is invited to enter:
    1) the name of a currently existing UDF function,
    2) a desired function description, and
    3) up to 20 desired argument descriptions.
    The macro then uses the MacroOptions method to assign the function description and the argument descriptions to the UDF whose name was entered in the first textbox.

    The macro works okay, but instead of just presenting empty textboxes for the function description and argument descriptions, Id like to present to the user the function description and argument descriptions that are currently assigned to the function. This would ease the process of refining and improving the function and argument descriptions....
    1 week ago
  • pierrechapar
    Optimize this vba code
    by pierrechapar
    Hi guys,

    It's my first time posting, although I've been reading from this forum for a while now.

    Lets see if anyone can help me with this code.

    The code works fine, it does what it's supposed to, but it takes ages to do it. And by ages I mean over 9 mins. And the truth is that I need to run it on 8 sheets. So over 9 mins x 8 sheets = a life time

    As a backgroud of my spreadsheet, let me tell you that it's a 65 Mb file. It has a conection to a folder, where it gathers de data as a data model. It has 15 sheets. In most of the there are pivot tables conected to the data model.

    Here is the code

    Sub Monetry_cambio_spain()

    Dim q As Range

    Worksheets("Monetary Spain").Activate
    5 days ago
  • jo15765
    Use Variant Variable In Filter Condition In VBA
    by jo15765
    I am wanting to use VBA to filter a worksheet. I am reading the userID's from the worksheet like this
    Dim userID As Variant
    Dim uID As Variant
    userID = Sheets("Data").Range("B2:B101").Value
    Then I try to do the below, to use VBA to filter it filters out all rows acting as if the value does not exist?
    For Each uID In userID
        Sheets("Data").Range("$A$1:$BV$153").AutoFilter Field:=2, Criteria1:=userID
    1 day ago