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: 106,713 Posts: 590,941
106,713 590,941
Excel VBA / Macros (2,952/16,051)
Excel Formulas (500/2,567)
Excel General (103,078/572,099)
Excel FAQ (165/175)
Code Review (8/41)
PLEASE PAY (via PayPal) 10% of your cost to [email protected] BEFORE you post. Then pay the remaining 90% to the person who completes the job on completion.
Topics: 1,377 Posts: 16,023
1,377 16,023
Topics: 6,411 Posts: 28,372
6,411 28,372
Excel and/or Word Help (1,246/5,199)
Excel and/or Access Help (2,599/11,464)
Excel and/or Email Help (1,261/5,453)
Excel and/or SQL Help (820/3,814)
No questions in this forum please.
Topics: 591 Posts: 2,391
591 2,391
Topics: 979 Posts: 6,414
Last Post: Word Play
979 6,414
Word Play
by AliGW
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (484/3,918)
Test Area (460/2,382)
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 4120 users online. 25 members and 4095 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 120,747   Posts: 659,807   Members: 310,855   Active Members: 486
Welcome to our newest member, berny978.

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


  • Foncesa
    Move Duplicates

    Column B contains alpha-numeric values I need a formula or macro which will move the duplicates, search and move complete row once duplicate value is found in column B.


    41 minutes ago
  • paulie77
    2 header rows that need to be removed without affecting csv
    Hi all
    Working with a system that extracts 3-4 reports to SFTP site to be used to upload into another application. We have all the columns mapped ok and data is good - issue is that the extract data starts with line 3 so we need an automated tool of ALWAYS removing first 2 rows/lines - is this possible?...
    3 hours ago
  • noobexcel12
    Autogeneration Serial Number problem
    Hello everyone,

    i'm writing here because i'm a bit stuck.

    I'm a beginner user of Excel VBA..

    I'm trying to create a Userform where I can add new entry for my database.
    The userform is working but i'd like to add a Line code to generate automatically a Serial/Order Number.

    I have already found here some similar post, I tried to do like the post says but it doesn't work on my UserForm.
    Anyone can check my File and tell me where is the problem?

    I attached the file in this Post...
    4 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • B.W.B.
    Extract numbers from text?

    I have a range, let's say, A1:D9, in which are values like: "", sometext1234, 1234text, -1234, 1234, tetxt1234tetxt...
    I have this code which is working perfectly but, problem is in that MINUS1234. I just want to Sum these numbers. Code is working only if num is positive

    Function Add_Numeric(iRng As Range) As Long
    For Each cell In iRng
        l = Len(cell)
        If l = 0 Then GoTo nextcell
        numstr = ""
        For i = 1 To l
            If IsNumeric(Mid(cell, i, 1)) Then numstr = numstr & Mid(cell, i, 1)
        Next i
        Add_Numeric = Add_Numeric + numstr * 1
    Next cell
    End Function
    August 23rd, 2017, 00:45
  • wilneeth
    Insert photos into a cell and lock to cell
    I'm happy to pay for a good solution. I use Excel 365 (continuously updated).
    The attached spreadsheet is the form I want to use to inspect a facility and record issues.
    I want to use a tablet with a camera, walk around, go to the Photo cell for Item 1, take a Pic by going Insert>Picture>Camera.
    I also need the photo number / filename to automatically go into the Photo No field. This will enable me to find the photo separately if, e.g. I need an enlargement of something.
    Then I can populate the other fields from dropdown lists or manually, as I'm looking at Item 1 in the field. That completes Item 1, and I move on to Item 2.
    My need is to have the photo locked to the selected cell as I take the pic, the pic saved in the same folder as the spreadsheet,...
    2 weeks ago
  • JohnGreen2
    Match function to look up match from Combobox on a datepicker with a combobox $20
    I have a commandbutton I would like to do a match function x2 first to find the column for the selected date and then to see if the combobox value is in that column.Combobox 2 is date field....if I select a date it will select a valueCombobox3.That value I want a match function on the datepicker on that day underneaths data to say match found or match not found in the listbox...In my dummy sheet I have put data on the 15 October 2017 to test....
    1 week ago
  • branchx
    How to copy a row & column of text if row & column contains certain text (VBA)
    How to copy only X row & X column of text if row & column contains X text (VBA)? How to copy from sheet1 to sheet2?

    5 days ago
  • 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