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: 108,594 Posts: 598,993
108,594 598,993
Excel VBA / Macros (4,359/21,957)
Excel Formulas (803/4,005)
Excel General (103,209/572,677)
Excel FAQ (165/175)
Code Review (15/61)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,426 Posts: 16,385
1,426 16,385
Topics: 6,453 Posts: 28,465
6,453 28,465
Excel and/or Word Help (1,256/5,222)
Excel and/or Access Help (2,603/11,474)
Excel and/or Email Help (1,268/5,466)
Excel and/or SQL Help (824/3,825)
No questions in this forum please.
Topics: 596 Posts: 2,415
596 2,415
Topics: 990 Posts: 6,541
990 6,541
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (498/4,049)
Test Area (462/2,383)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 17 Posts: 18
Last Post: Vlookup and Hlookup
17 18
Vlookup and Hlookup
by AliGW
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 3368 users online. 19 members and 3349 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 122,757   Posts: 668,863   Members: 314,777   Active Members: 667
Welcome to our newest member, chbix.

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


  • chbix
    Merged Cells and using offset
    So, I have tried to use the center across section and it will not work for the application and I have no choice but to use merged cells. center across section wont work because I want A4 B4 as one heading and c4 d4 as another and so on. When I do A4B4 as "center across section" and then c4d4 as another "center across section" it makes text in A4 center in between A4 and D4 not A4 B4.

    That being said. I am trying to have a cell checked for empty,
    if its empty, I want it to delete a picture, text, and pictures/text in comments.
    It works for the most part.
    but it stalls and doesnt complete the operation and not sure what i am missing.

    Dim Rng As Range
        Dim pic As Picture
        Dim cmt As Comment
    2 hours ago
  • OJEDA397
    Match a Cell Value to one in a range, return value base on cell text
    Good Day,

    I would like help from the collective knowledge of this forum:

    I have created a small user form so that I can collect a bit of information on how long it is taking to complete a work order. this user form then extracts information on whether the user was working on one or up to 12 work orders at once. the form gives a time stamp and assigns an "in" or "out" . the attached file has the output of this user form.

    the part that I am struggling with is to match up the list on " sheet 2 " to the range of numbers on "sheet 1" and determine whether it was in or out.

    any help would be greatly appreciated....
    5 hours ago
  • Bluemachine
    Write Part of Array to Range
    I can use a little help on this question.

    I have a 3 Dim dinamic array, say, ArrV(1 to 2, 1 to 5000, 1 to 500) as double and I am looking for a fast way to write a 2 Dim part of it ArrV(1, allrows, allcolumns) to a range, such as

    RangeRg = ArrV(1), or RangeRg = ArrV(2)
    This results in a compiler error

    ArrV is dinamic. Only the 1st dimension is fixed 1 to 2.

    If the array ArrV was 2 Dim then RangeRg= ArrV does the job clean and quickly.
    But as it is a 3 dim array, how can I do it without having to copy every single element to a new 2 dim array?

    Is there a way to do it FAST?

    Thanks in advance for any help or suggestions....
    5 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • CanadianInvader
    Link Chart Title To Cell
    Ok, so I know that I can manually select a chart's title and enter '=A1' in the formula box.

    What I need is VBA code that does exactly this. The reason I need this is because I'm looking to create a chart entirely in VBA code -- no user interaction necessary. From the user's perspective, it works like this: select a range, click a command button, and a new chart is created.

    I have tried the following:
    <chart>.ChartTitle.Text = Sheet1.Range("A1")
    ...which works insofar as the title is set to the cell's value, but the title isn't updated when the cell's value changes -- IOW, the code above only sets the title to the cell's value, it doesn't link it.

    I can write code in the Workbook_SheetChange event handler to...
    April 14th, 2008, 02:23
  • Vnova33
    Macro to pull certain certain cells from multiple Excel files
    Hi All,

    I run a small business and have done my own record keeping for years. I have over 750 spreadsheets of transactions from customers that have rows such as customer name, transaction date, amount, etc. Each customer only has one spreadsheet, so if they made multiple transactions I would just add the record of the transaction under the previous ones.

    My dilemma now is I want to summarize it all in one chart so I can sum up how many transactions I've had a month. What I would like to do is run a macro to go through the files and pull the customer's name and the transaction dates for any of the transactions that customer might have had. The customer's name is always in CELL B3 next to a Cell that says "Customer Name", however the transaction date may...
    May 9th, 2017, 10:10
  • aja6556
    Condensing data in multiple rows down to a single row based on a unique identifier
    Hi I am looking for some help with an excel task. We have a spreadsheet that has data on multiple rows that we'd like condensed into one row. The rows have the same unique ID but a different number of rows of data. We'd like to be condensed onto one row, and then the duplicates names removed.

    Column A has the unique ID that ties all the records together. Here is an explanation of the Record Types (column C):
    LED - This is the lead's creation date.
    CAL - Contains contact info like email, phone, and address
    GRP - What groups the lead was in
    CMP - What campaigns the lead was in
    NOT - Notes entered for the lead...
    3 weeks ago
  • colonel179
    Copy all rows from table

    I would like to find a solution to this issue I am having.

    I have a button that runs this code:

    Sub CopyValues()
    Dim ws As Worksheet
    Set ws = Worksheets("report")
    Dim oNewRow As ListRow
    Set oNewRow = ThisWorkbook.Worksheets("report").Range("Table1").ListObject.ListRows.Add(AlwaysInsert:=True)
    With ThisWorkbook.Sheets(1)
    oNewRow.Range.Cells(1, 1).Value = ThisWorkbook.Worksheets(1).Range("A4")
    oNewRow.Range.Cells(1, 2).Value = ThisWorkbook.Worksheets(1).Range("B4")
    oNewRow.Range.Cells(1, 3).Value = ThisWorkbook.Worksheets(1).Range("D4")
    oNewRow.Range.Cells(1, 4).Value = ThisWorkbook.Worksheets(1).Range("C4")
    1 week ago
  • Hibernted
    vba copy to variable range in other workbook based on value, loop through open wbs
    I need to copy a fixed range of data from one workbook (wbsource) to all other open workbooks (wbdestin). The destination sheet (wsdestin) in every wbdestin is based on a value in the wsdestin.worksheets("ClientBio") (all open workbooks have the same worksheet names, and rows/columns). The destination range (rngdestin1, rngdstin2 or rnddestin3) is also based on another value in the "ClientBio" worksheet. Once the values are copied to the appropriate destination, the process is repeated on every other open workbook that starts with name "GroupClient*.xlsm".

    I now need to determine the destination range based on the rngdestin(1) (2) or (3). If "A9" in "ClientBio" has a value of "Day1", the data is pasted to rngdestin1;...
    5 days ago