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,274 Posts: 602,471
109,274 602,471
Excel VBA / Macros (4,872/24,555)
Excel Formulas (893/4,517)
Excel General (103,273/572,999)
Excel FAQ (165/175)
Code Review (20/81)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,448 Posts: 16,564
1,448 16,564
Topics: 6,456 Posts: 28,471
6,456 28,471
Excel and/or Word Help (1,257/5,225)
Excel and/or Access Help (2,604/11,478)
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: 992 Posts: 6,565
Last Post: Chat Room
992 6,565
Chat Room
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (504/4,077)
Test Area (459/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 19 Posts: 21
19 21
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 4249 users online. 13 members and 4236 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 123,475   Posts: 672,609   Members: 316,037   Active Members: 503
Welcome to our newest member, kaido.

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


  • atsomallat
    Userform = Not enough memory resources to process this command
    Hi im kind of new with this vba. So i have this userform that populates the listbox from another workbook. There is some client information like client number, name, phone number etc
    I can click and choose those client and import the data to the file the userform was opened. It was working fine for sometime even when there was alot more clients,now i only have 2 clients there so it should not be about the memory, but now i got this memory error: "Not enough memoryresources to process this command"
    I did some research and thought it might be corrupted userform but i didnt want to start coding it from the beginning. Maybe someone could give me some advices.

    Sorry for my rough english :D

    Thanks already.

    Here is the initialize...
    1 hour ago
  • harsha6989
    Macro needed to put , for barcoded input in cell
    I have a barcode reader to read some stuffs. When ever i scan the number will come and sit in A column I.e, A2, A3 etc. But i need a comma to placed automatically if i need to input multiple stuffs in same cell.
    Please help me with a macro
    4 hours ago
  • Kineve
    Create unique list without blank values

    I've got a single-column output of values in a Google sheet (the output is from a http pull so the data refreshes every day). I need to basically de-dupe the list and remove blank cells so as to have 1 column, unique values, no spaces. Does anyone know a formula that would be able to do this? Closest I have got is =unique(query(A2:A,"select A where A<>''")) but this still seems to give me a single blank value.
    7 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • TinoBradica
    Combine/Merge Multiple workbooks/sheets
    Hello, New here. Hope Im in the right place.
    I found a thread that seems to be same problem I am having. I tried using the code provided to other member and am NOT getting results. Here is what I need.
    I have 500 workbooks, all with same header and sheet names.
    I need to combine the content all into a single workbook with all sheets merged into workbook. data all starts at A2 and varies in row content from 1 row to 5000 per workbook/sheet.
    The code is what I found on this site and tried to modify to work before I asked the question.

    Option Explicit

    Sub Extract_Files()

    Application.ScreenUpdating = False

    Dim ParentFolder As String
    Dim WS As Worksheet
    Dim ThisWB As Workbook
    Dim ThisWS As...
    October 5th, 2018, 00:02
  • natrajc
    Automatically Extract URL from Browser
    Hello Experts!

    Was wondering if someone could help me with the following:

    I need the url of any website opened by an operator to be copied into an Excel file with a date and time stamp.

    The operator uses incognito mode , too, at times.

    The idea of this is to be able to backtrack and find a particular operator who did not update the url (s)he opened to an excel sheet, which is what is required of the operator.

    Thank you in advance.


    Went through a search and found five pages that pulled up for a search on "Extracting URL automatically", but was unable to make any headway.


    As evidenced by my past efforts in excel/VBA, I'm not the sharpest tool in the box
    1 week ago
  • scottparker101
    New code to write cell location

    mlooking for help with writing a macro to find numbers 1 to 12 and write the cell location of the found numbers.

    The cell range is as follows: B5:B16, F5:F16, J5:J16. Search for numbers 1 to 12. A positive result only occurs when the 3 cells to the right of a found number also has numbers in it. This is only a sample Excel sheet and I will have to make cell location changes for everything so please do not hard code. Also, could the positive number cell location be written to the corresponding number in the following cells:

    Number 1 write to cell location B2

    Number 2 write to cell location C2

    Number 3 write to cell location D2

    Number 4 write to cell location E2

    Number 5 write...
    1 week ago
  • dockerjack
    VBA and Macro help needed please!
    Hi all

    First post and fairly new to the world of VBA and Macros, hoping someone can help point me in the right direction.

    I have attached the spreadsheet I am working on, hope this helps to understand my issues.

    What I'm trying to achieve is some autonomy with my spreadsheet to speed up the recording of simple data. I have designed a working user form with no issues, as a front end for the data recording.

    The functionality I'd like to be able to add is as follows:
    • Selecting a single row of data and cut/copy to another worksheet
    • Be able to have the user select which months worksheet they want to move the data to from the main sales data worksheet
    • Ideally achieve this with the use of command buttons
    Hopefully this will make more...
    1 week ago
  • d.henderson1
    Hyperlink to another sheet in workbook
    I am trying to find a way to make references to other places in the workbook into hyperlinks. For example, if there is a value who's matching value (all values have one matching value) is found on tab C1, I want the C1 reference to also be a hyperlink to the matching value.

    To clarify, what I have right now:
    Value Reference
    45 C1.4 (4 is the page number)

    What I want: C1.4 to link to the location of the matching 45.

    Here is what I have so far, but I have gotten several errors on the hyperlink.add line.

    Sub createHyperlinks()
    Dim Lastrow As Long
    Dim i As Long
    Dim r As Range
    Dim cell As Range

    Lastrow = Cells(Rows.Count, 1).End(xlUp).Row...
    4 days ago