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,632 Posts: 609,388
110,632 609,388
Excel VBA / Macros (5,897/29,884)
Excel Formulas (1,068/5,381)
Excel General (103,393/573,556)
Excel FAQ (165/175)
Code Review (26/140)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,486 Posts: 16,904
1,486 16,904
Topics: 6,469 Posts: 28,510
6,469 28,510
Excel and/or Word Help (1,264/5,251)
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
598 2,432
Listing of Files and Worksheets
by freycom
Topics: 999 Posts: 6,609
Last Post: Many Happy returns
999 6,609
Many Happy returns
by S O
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (511/4,119)
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 2581 users online. 15 members and 2566 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 124,909   Posts: 680,179   Members: 318,754   Active Members: 525
Welcome to our newest member, ltxbuilder.

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


  • JCabral
    Highlight visible items of ListBox based on a condition
    by JCabral

    I have a problem that I don't know if it can be solved, but here is for sure the best place to know, this is:

    - I have a ListBox with several columns, in the example that attachment I just put with three but may be 14, where I only want to show certain columns, in this case only show the first two columns, and only show 12 ListBox items at a time;
    - That is the Height, Width and number of visible items (ListBox lines) are fixed - in this case there are 12.

    The intention was that whenever the value of the third column was different from "", ie whenever there is value, the color of the label, which is now red, would change to yellow (or any other color), without "Clicking" in the ListBox, ie when I first show the ListBox,...
    13 hours ago
  • cobber1418
    How to call subs multiple times
    by cobber1418
    Hi All
    I need help to call a sub multiple times. I know how to call a sub a second time but I don't know how to jump the next subs to get back to where I was when I called the sub.

    Thanks in advance, Cobber
    13 hours ago
  • moyad612013
    Copy & Paste to the next empty row/column in a new worksheet, multiple times
    by moyad612013
    Hello - I have a worksheet with a lot of raw data scattered in various cells. But I need to organize that raw data into specific columns on another worksheet. I tried creating a macro to copy from the raw worksheet and paste into the organized worksheet, into the next empty row, but when I run the macro it replaces the data previously copied and pasted. How can I copy from the raw worksheet and paste into the organized worksheet, into the next empty row; and be able to do this multiple times?
    Here's a copy of my current code:
    Sub Macro2()
    ' Macro2 Macro

    Application.CutCopyMode = False
    20 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • LEHoisveen
    Print multiple sheets to multiple printers, multiple copies?
    by LEHoisveen
    Hi, I'm a new at VBA and Macros.

    I have a spreadsheet that contains multiple sheets,
    And I want to print three different sheets.
    Sheet number one and two I want to print on one printer, and sheet number three I want to print on another printer.

    Sheet number one, I need two copies of the first page, no other magic.

    Sheet number two, I need two copies of this sheet, and its here it starts to be complicated.
    This sheet uses sheet zero as a database, and it acts like a waybill, where customer and products are listed.
    The are selected from sheet zero and arranged after trip number.
    So i want to copies of this sheet for each customer in trip number "n".

    Sheet number three, i need x number of this sheet,...
    January 7th, 2019, 19:44
  • skrow
    Macro: cut data (based on selected row), find and paste row beneath unique cell macro
    by skrow
    I am new to VBA and am still learning. I would like to make what I imagine is a pretty straightforward macro. I would like to make a macro that will cut a selected row, find a unique cell in the same sheet and paste the row directly beneath the row with the unique cell. Any help is appreciated.
    5 days ago
  • Rajat28
    Excel VBA - Copy & Paste from Multiple Workbooks
    by Rajat28

    I want some help with VBA code.I have few workbooks and each workbook has multiple sheets. I want to move the data from the different workbooks into one master file. The files are in different location & all have the same headers.
    I want to be able to copy the data & paste into the master sheet. Folders have multiple files. Also the header in each file is same. So I don't want the header to get copied.

    Please help me out here.
    Thank you for the help.
    5 days ago
  • GoCavs
    $40 USD: VBA-Row Height AutoFit for UDF
    by GoCavs
    10% Prepaid to Ozgrid

    I am using a UDF to concatenate similar values based on criteria in columns in a worksheet (Review). The formula that calls the UDF is in a table on another sheet (Ratings). The table will show names in a cell based on matches in the criteria in the formula. Also, the UDF places each new value in the cell under each other similar to CHAR (10) to make it look clean. As values change based on input in columns from the Review sheet (Column Y, VCC Rating), the rows in the table do not want to expand or "Autofit" to account to more values being added or being removed from cells. Is there code that can be added to the UDF that will automatically autofit the rows of the table after values are changed in Column Y in the Review sheet. Every other column...
    4 days ago
  • ashming
    Selecting cells using the IF function in multiples
    by ashming
    I have been trying to add relevant info into 1 cell on Sheet 2 from Sheet1 using the IF function, but need help to add more notes from different cells as there is usually more than 1.
    In this case there is 3, but can only get 1 showing....
    4 days ago