forum.ozgrid.com Open in urlscan Pro
62.113.233.135  Public Scan

Form analysis
1 forms found in the DOM

POST https://forum.ozgrid.com/index.php?search/

<form method="post" action="https://forum.ozgrid.com/index.php?search/">
  <div id="pageHeaderSearchInputContainer" class="pageHeaderSearchInputContainer">
    <div class="pageHeaderSearchType dropdown" id="wcf0">
      <a href="#" class="button dropdownToggle jsDropdownEnabled" id="pageHeaderSearchTypeSelect" role="button" tabindex="0" aria-haspopup="true" aria-expanded="false" data-target="wcf0">
					<span class="pageHeaderSearchTypeLabel">Forum</span>
					<fa-icon size="16" name="caret-down" solid="" aria-hidden="true" translate="no"></fa-icon>
				</a>
    </div>
    <input type="search" name="q" id="pageHeaderSearchInput" class="pageHeaderSearchInput" placeholder="Search …" autocomplete="off" value="">
    <button type="submit" class="pageHeaderSearchInputButton button" title="Search">
      <fa-icon size="16" name="magnifying-glass" solid="" aria-hidden="true" translate="no"></fa-icon>
    </button>
    <div id="pageHeaderSearchParameters"></div>
  </div>
</form>

Text Content

 1. OzGrid
    1. Excel/VBA Consultancy
    2. OzGrid Store
    3. Training
    4. Freebies
 2. Forum
    1. Unresolved Threads
    2. Forum Rules
 3. Dashboard
 4. Articles

 * Login or register
   
 * Search

Forum




OZGRID FREE EXCEL/VBA HELP FORUM

The best online resource for all your Excel & VBA requirements

 * Create Thread

Mark All as Read



HELP FORUMS

Pick the APPROPRIATE category below to post your question and/or answer
questions.


EXCEL VBA / MACROS

0
Questions specifically related to excel programming
Threads 9.4k Posts 54k
Last Posts
Refer one routine directly after each button is clicked
rory September 30, 2024 at 9:39 AM
PasteSpecial Method of Range Class Failed
rory September 25, 2024 at 10:29 AM


EXCEL FORMULAS

0

Questions related specifically to the use of Excel formulas.

Threads 1.6k Posts 8.5k
Last Posts
Conditional formatting in cells with text
GradB September 26, 2024 at 6:33 AM
Combined Sum with Index and Match
mar050703 September 23, 2024 at 7:34 PM


CODE REVIEW

0
A place to share your WORKING code for others to review and critique. Use this
forum to gain an insight into efficiency and best practice when coding.
Threads 51 Posts 228
Last Posts
Rollforward Tool (for copying files en masse from one date dependent location to
another)
Greychild March 26, 2024 at 10:31 AM
VBA For Comparing Data In Sheet 1 & Sheet 2
JBMS February 11, 2024 at 3:47 AM


EXCEL GENERAL

0

For all general questions relating to Excel but not including VBA or formulas.

Threads 103k Posts 574k
Last Posts
Graph that skips some values in between
gijsmo September 29, 2024 at 6:45 AM
Allow Hyperlink Clicks On Protected Sheet
Newcomer September 4, 2024 at 10:07 AM


EXCEL FAQ

0
A collection of the most frequently asked questions in the Excel/VBA forum.
Check in Here Before Posting
Threads 168 Posts 190
Last Posts
Excel Question
Robert Minkow September 17, 2024 at 7:24 PM
Excel Versions Explained
Pecoflyer April 8, 2024 at 8:10 AM


POWER EXCEL

0
For queries related to Power Excel products (e.g. Power Pivot, Power BI...)
Threads 30 Posts 137
Last Posts
Cross Post Issues in creating a calculated measure across 3 different data
sources
mrbuttons June 24, 2024 at 1:52 AM
DAX formula that calculate one person vs Others in the group data
7absinth February 14, 2024 at 2:17 PM
Sub-forums
Power BI
Power Pivot
Power Query


HIRE HELP

0
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Threads 1.5k Posts 17k
Last Posts
anonymise my account
user177842 August 28, 2024 at 10:37 AM
How can I delete my account ?
rory March 19, 2024 at 11:41 AM


OTHER SOFTWARE APPLICATIONS


EXCEL AND/OR WORD HELP

0
Only for questions that pertain to Word and Excel, or Word only. SEARCH. Today's
Last 10 Questions | Recovery: Document | Password
Threads 1.3k Posts 5.4k
Last Posts
Hours Calculation
Pecoflyer April 8, 2024 at 8:08 AM
First Hit of a Searched Keyword not Highlighted
RSquirrel November 23, 2023 at 8:13 PM


EXCEL AND/OR ACCESS HELP

0
Only for questions that pertain to Access and Excel, or Access only. SEARCH.
Today's Last 10 Questions | Recovery: Database | Password
Threads 2.6k Posts 11k
Last Posts
importar dados da planilha1 ( excel) para o BdDados na TdTitulo no acess em vba
Geraldo Pereira December 10, 2023 at 12:21 AM
Ajout de combobox
cytop August 17, 2023 at 4:13 PM


EXCEL AND/OR EMAIL HELP

0
For questions that pertain to any email package, or Excel and any email package.
SEARCH. Today's Last 10 Questions | Recovery: Email | Password
Threads 1.2k Posts 5.4k
Last Posts
Copy range, paste in outlook mail and send e-mail
iamnatecanlas April 20, 2022 at 2:21 PM
Email Individual or Selected Individuals Using VBA/Macro Actions
Logit April 12, 2022 at 4:04 AM


EXCEL AND/OR POWERPOINT HELP

0
Only for questions that pertain to Powerpoint and Excel, or Powerpoint only.
SEARCH. Today's Last 10 Questions | Recovery: Presentation | Password
Threads 366 Posts 1.7k
Last Posts
How to Randomize Only VISIBLE Slides, Not Hidden Slides??
royUK February 24, 2022 at 2:09 PM
Reiterating Sub TextBox1_Change() efficiently
rory August 12, 2021 at 9:54 AM


EXCEL AND WEB BROWSERS HELP

0
Only for questions that pertain to Web Browsers and Excel. SEARCH. Today's Last
10 Questions | Recovery: Document | Password
Threads 133 Posts 856
Last Posts
Power Query error when table only has one row
MVS2012 July 12, 2023 at 12:46 PM
Enter line break in excel
bruce_banner August 11, 2021 at 10:40 AM


EXCEL AND/OR SQL HELP

0
For questions, discussion and knowledge sharing pertaining to the SQL Query
Language (e.g. MS SQL, MySQL, Access Queries and Crystal Reports). SEARCH.
Today's Last 10 Questions
Threads 816 Posts 3.8k
Last Posts
what is best to hold my massive Data
rory December 14, 2021 at 9:06 AM
SQL Select Where Clause doesnt return any result
rory June 19, 2020 at 8:23 AM


TIP, TRICKS & CODE (NO QUESTIONS)

No questions in ANY forums in this category please.


TIP, TRICKS & CODE

0
No questions in this forum please.
Threads 602 Posts 2.5k
Last Posts
VBA To Add / Subtract / Multiply / Divide Every Cell by X
trunten December 16, 2023 at 1:52 PM
CSV file with Comma's between quotation marks - Reg Expression - CSV to Array
pike May 28, 2023 at 10:58 AM


ADVANCED EXCEL INTEGRATION

0
Solutions for integrating Excel with other applications with advanced
technologies.
Threads 25 Posts 55
Last Posts
Office 365 login
Carim December 4, 2019 at 7:38 AM
Using worksheet data in the chart office web component
kitisn01 March 6, 2018 at 8:41 AM


XL-DENNIS CORNER IN THE EXCEL-WORLD

0
A vagabond has finally find his home. Here you will find XL-Dennis comments,
thoughts, tips & tricks about Excel, Office, Visual Studio, databases and other
developing tools.
Threads 11 Posts 26
Last Posts
Thank You and goodbye
Dave Hawley February 3, 2006 at 1:42 AM
WikiCalc, 12, databases and some tips & tricks
XL-Dennis December 1, 2005 at 4:05 PM


NON CONFIDENTIAL SHOWCASE

0
If you have finished a project that this forum has helped you with, you can post
it here and perhaps give back by sharing your knowledge.
Threads 25 Posts 116
Last Posts
Sudoku Auto Solver
iwrk4dedpr November 17, 2019 at 9:54 PM
Controlling Environmental Parameters During Procedures Calls
Reafidy July 1, 2008 at 10:15 PM


OTHER STUFF


DAVE HAWLEY FOUNDATION

0
Dave passed away in 2013 after a long fight with brain disease. This Foundation
has been established in his memory to help young, vulnerable children gain
education via computers. The Foundation intends to select a project every year
to (a) assist where we can and (b) honour and support the memory of Dave and
what he contributed to the Excel community.
Threads 4 Posts 7
Last Posts
Muscular Dystrophy Western Australia
Raina May 20, 2018 at 7:14 AM
Auscam freedom project underway
apo September 23, 2016 at 12:41 PM


NEWSLETTERS

0
OzGrid Excel Newsletters
Threads 3 Posts 3
Last Posts
April 2016 Newsletter
Dave Hawley April 21, 2016 at 8:22 AM
December 2015 Newsletter
Dave Hawley December 21, 2015 at 2:05 PM


COMPETITIONS

0
Threads 3 Posts 13
Last Posts
CODE GOLF - April 2016 Answers
mikeopolo May 10, 2016 at 4:45 AM
CODE GOLF - December 2015 Answers
S M C January 16, 2016 at 10:39 AM


HAV-A-CHAT

0
General chit chat.
Threads 505 Posts 4k
Last Posts
Not getting notifications
troy11 January 12, 2021 at 8:05 AM
Season greetings
AliGW December 22, 2019 at 7:46 AM


BOOK SUGGESTIONS & REVIEWS

0
Use this forum ask others about any technical type book. Also post your reviews
of other books.
Threads 16 Posts 93
Last Posts
Vba Book Suggestion
Carim January 16, 2023 at 2:23 PM
Excel VBA book needed
Logit August 9, 2022 at 1:57 AM


EXCEL DEVELOPMENT & CONSULTANCY

0
Let Ozgrid give you a FREE quote on any development work or consultancy.
Threads 0 Posts 0



TEST AREA

0
Use this area to test your signatures, adding HTML links, code etc.
Threads 461 Posts 2.4k
Last Posts
Test for Admin
S O November 12, 2022 at 7:32 AM
test
AliGW May 10, 2020 at 12:37 PM


OZMETA

0
A forum for any topics about the forum itself - feedback, suggestions, questions
etc.
Threads 6 Posts 41
Last Posts
Logging out of Ozgrid forum (Urgent)
AliGW August 18, 2024 at 7:33 AM
My level was set back to beginner, was there a reason?
S O May 18, 2020 at 9:09 AM


EXCEL SEARCH & RESOURCES

Links to Excel sites and Excel specific search engines.


FREE EXCEL ADD-INS

0
Links to free Excel add-in pages & specific free Excel add-in search engine
Threads 0 Posts 0



FREE EXCEL TEMPLATES

0
Links to free Excel template pages & specific free Excel template search engine
Threads 0 Posts 0



FREE EXCEL TRAINING & TUTORIALS

0
Links to free Excel training pages & specific free Excel training search engine
Threads 3 Posts 6
Last Posts
Free Online Tool to Format Formulas
Carim January 3, 2023 at 6:27 AM
If false, do nothing with current cell value
royUK April 2, 2022 at 7:35 AM


FORUMS & NEWSGROUPS

0
Links to Excel forums/newsgroups & search engine.
Threads 0 Posts 0



NEWSLETTERS

0
Links to Excel newsletters & specific Excel newsletter search engine
Threads 0 Posts 0



EXCEL BLOGS

0
Links to Excel Blogs & search engine.
Threads 1 Posts 1
Last Posts
9 Quick Tips to Improve VBA Macro Performance.
Raina January 12, 2019 at 6:32 AM


EXCEL MVP SITES

0
Links to Excel MVP sites & search engine.
Threads 0 Posts 0



NON ENGLISH EXCEL SITES

0
Links to non English Excel sites & search engine.
Threads 0 Posts 0



PIVOT TABLES

0
Links to Excel site pages focused on Excel Pivot Tables & specific Pivot Table
search engine.
Threads 1 Posts 15
Last Posts
Pivot Table/Slicers
jpetraityte April 13, 2020 at 6:48 PM


GAMES

0
Links to Excel sites focused on Excel games & specific Excel games search engine
Threads 2 Posts 4
Last Posts
Excel Wordle
S O March 8, 2022 at 9:36 PM
Knitting patterns
Carim September 27, 2018 at 11:47 AM


CHARTS

0
Links to Excel sites focused on Excel charting & specific charting search engine
Threads 1 Posts 1
Last Posts
In a chart of a single series have each bar have 2 labels, 1 the value of the
bar and 2 the percentage of the total
Checkovsky December 19, 2023 at 10:03 PM


EXCEL ALTERNATIVES

0
Links to Excel alternatives & specific Excel alternatives search engine
Threads 0 Posts 0



SOLVER

0
Links to Excel sites focused on Excel solver & specific solver search engine.
Threads 0 Posts 0



EXCEL 2007

0
Links to Excel 2007 pages & search engine.
Threads 0 Posts 0



EXCEL 2007 VBA

0
Links to Excel 2007 VBA pages & search engine.
Threads 0 Posts 0



BLOGS


OZGRID UPDATES

0
Updates on OzGrid, the Site and the Forum.
Threads 1 Posts 7
Last Posts
The Wizard of Oz
Unk November 7, 2017 at 7:08 PM


ARTICLES

0
CMS Home Page
Threads 2 Posts 8
Last Posts
Anatomy of a Good Thread Title
Carim February 7, 2020 at 9:34 PM
Forum Rules
S O October 3, 2017 at 12:29 AM




LATEST POSTS


 * REFER ONE ROUTINE DIRECTLY AFTER EACH BUTTON IS CLICKED
   
   rory September 30, 2024 at 9:39 AM


 * GRAPH THAT SKIPS SOME VALUES IN BETWEEN
   
   gijsmo September 29, 2024 at 6:45 AM


 * CONDITIONAL FORMATTING IN CELLS WITH TEXT
   
   GradB September 26, 2024 at 6:33 AM


 * PASTESPECIAL METHOD OF RANGE CLASS FAILED
   
   rory September 25, 2024 at 10:29 AM


 * COMBINED SUM WITH INDEX AND MATCH
   
   mar050703 September 23, 2024 at 7:34 PM


HOT THREADS


 * REFER ONE ROUTINE DIRECTLY AFTER EACH BUTTON IS CLICKED
   
   1 Reply, 304 Views, 4 days ago


 * MIGRATION AFTER 3 YEARS?
   
   12 Replies, 12,365,976 Views, 15 years ago


 * GRAPH THAT SKIPS SOME VALUES IN BETWEEN
   
   8 Replies, 121 Views, 6 days ago


 * PASTESPECIAL METHOD OF RANGE CLASS FAILED
   
   3 Replies, 380 Views, A week ago


 * SPLIT DATA BASED ON SERIAL NUMBER AND PASTE BESIDE
   
   16 Replies, 1,494 Views, A month ago


THREAD TAG CLOUD

 * array
 * Chart
 * Code
 * Combobox
 * command button
 * conditional formatting
 * copy
 * copy and paste
 * copy and paste value
 * CountIf
 * Date
 * drop down list
 * dynamic
 * error
 * Excel
 * excel 365
 * Excel 2007
 * Excel 2016
 * excel VBA
 * excelvba
 * Excel_Vba
 * Filter
 * formula
 * formulas
 * function
 * Help
 * html
 * Hyperlink
 * index and match
 * Listbox
 * Loop
 * macro
 * macros
 * Named Range
 * Outlook
 * paste
 * pdf
 * Pivot table
 * range
 * rows
 * SEARCH
 * sum
 * Table
 * Textbox
 * userform
 * vba
 * VBA Array
 * VBA code
 * vlookup
 * word




STATISTICS

 * 348,597 Members
 * 128,776 Threads
 * 710,643 Posts (89.69 Posts per Day)

Latest Member: Nadiamoore.


USERS ONLINE

 * 1 Member and 203 Guests
 * Record: 17 Users (March 18, 2022 at 1:48 PM)

 * KjBox

Legend
 * Administrators
 * Super Moderators
 * OzMVP
 * OzVIP
 * OzWizard
 * Banned Users

 1. Privacy Policy

Do not share my Personal Information.
OzGrid Business Applications

Your browser has JavaScript disabled. If you would like to use all features of
this site, it is mandatory to enable JavaScript.
 * Everywhere
 * 
 * Articles
 * Pages
 * Forum
 * 
 * More Options

 * RSS Feed






DER SCHUTZ IHRER PRIVATSPHÄRE LIEGT UNS AM HERZEN!

Beim Besuch unserer Website können ausgewählte Unternehmen auf bestimmte
Informationen auf Ihrem Gerät und auf dieser Webseite zugreifen und diese
verwenden, um relevante Anzeigen oder personalisierte Inhalte zu schalten. Bitte
beachten Sie, dass Anzeigen dazu beitragen, dass unser Dienst weiterhin
kostenlos bleibt. Personenbezogene Daten werden basierend auf der Zustimmung
gemäß Artikel 6 Absatz 1 Buchstabe a des DSGVO-Rahmens im EU-Recht verarbeitet
oder wenn ein berechtigtes Interesse gemäß Artikel 6 Absatz 1 Buchstabe f
desselben vorliegt.


ERFAHREN SIE MEHR DARÜBER, WARUM IHNEN DIES ANGEZEIGT WIRD

Wir, der 'Herausgeber' und eine ausgewählte Gruppe von vertrauenswürdigen
Partnern (850), die als 'Anbieter' bezeichnet werden, benötigen Ihre Zustimmung
zum Zweck der Datenverarbeitung. Mit diesen Zwecken können wir Informationen auf
einem Gerät speichern und/oder abrufen, wie z. B. die Cookie-Verwaltung, und
personenbezogene Daten verarbeiten, wie Standardinformationen, die von einem
Gerät gesendet werden, und andere eindeutige Kennungen für personalisierte
Anzeigen und Inhalte, Anzeigen- und Inhaltsmessungen, Erkenntnisse über
Zielgruppen und Produktentwicklungen. Mit Ihrer Zustimmung können wir und unsere
Partner möglicherweise genaue Standortdaten verwenden und Geräteeigenschaften
zur Identifikation aktiv abfragen.

Sie können der oben beschriebenen Verarbeitung zustimmen oder auf detailliertere
Informationen zugreifen und Ihre Auswahl anpassen. Die erteilte Zustimmung gilt
nur für diese Website. Bitte beachten Sie, dass ein Teil der Verarbeitung Ihrer
personenbezogenen Daten möglicherweise auf berechtigten Interessen beruht, für
die Ihre Zustimmung nicht erforderlich ist. Sie haben jedoch das Recht, dem zu
widersprechen.

Sie können Ihre Einstellungen jederzeit auf der Datenschutzerklärungsseite auf
unserer Website ändern.

Auswahlmöglichkeiten anpassen
Alle akzeptieren und Website besuchen