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,827 Posts: 600,184
108,827 600,184
Excel VBA / Macros (4,526/22,829)
Excel Formulas (835/4,176)
Excel General (103,240/572,830)
Excel FAQ (165/175)
Code Review (15/61)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,429 Posts: 16,414
1,429 16,414
Topics: 6,454 Posts: 28,469
6,454 28,469
Excel and/or Word Help (1,257/5,225)
Excel and/or Access Help (2,603/11,475)
Excel and/or Email Help (1,269/5,468)
Excel and/or SQL Help (824/3,825)
No questions in this forum please.
Topics: 597 Posts: 2,416
597 2,416
Topics: 989 Posts: 6,540
989 6,540
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (500/4,053)
Test Area (459/2,378)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 18 Posts: 20
Last Post: Knitting patterns
18 20
Knitting patterns
by Carim
Newsletters (0/0)
Excel Blogs (0/0)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (1/2)

What's Going On & Who's Online?


There are currently 5612 users online. 27 members and 5585 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 122,996   Posts: 670,115   Members: 315,160   Active Members: 638
Welcome to our newest member, madz1101.

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


  • madz1101
    VBA code errors
    Hello Guys

    I need your help urgently. i am very new to VBA so please forgive me if i ask any noob question. I have written a small VBA code as below. I am getting error Run-time '1004': Method Range of object worksheet fail on the row If ws.Range("B") = "Fail" Then. Please check what i have done wrong in the code and how can i get the desired result

    What i am trying to achieve with the code is

    I have multiple excel sheets in one workbook. let says sheet1, sheet2 and so on... I also have one sheet "SNAGS"

    I have three columns in each sheets except SNAGS Sheet(Description, Result and Notes)

    so for each description user can either put pass or fail in result column. What i want to do is in the...
    1 hour ago
  • hightester
    automating a table to feed into a chart
    Hi all, hope you're doing well.I changed this to be posted here as I realised it may be some formula that can be integrated with the table

    I'm working on some final touches for a sheet I'm creating and having some trouble with a table. I can't seem to find answers anywhere.

    Basically I have a table (BE3:BK11) that is a rolling return of data entered in columns (M,P,S,V,Y,AB,AE). The data in the table will then feed into a chart with each column of the table having its own line. I understand that I can hit enter in the table and it will auto expand down and create a new table row.

    However, all the data in the table will be automated with formulas so I don't want to be touching or looking at it. I want to have it so that as I enter new data, for example,...
    2 hours ago
  • tbhendralesmana
    Save Excel file as JPG/PNG and send with outlook as attachment.
    Hi everyone,
    hope its ok to keep posting and ask in this forum,cause i'm still learning VBA.
    i wanted to have vba which allow me to save the file which in other sheet (lets pretend sheets 3) as JPG/PNG and send it with user outlook email. i've been trying several easy vba code but its doesn't work ( .
    3 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • rdblatch
    Multiple timers (stopwatches) in one worksheet
    Hi All,

    How can I make it so you can run several different timers on the same worksheet. Each timer should be able to be started at different times and stopped at different times. If the user minimizes the application, the timer should continue to run.

    I've seen several timers (stopwatches) in this forum, however none of them are for multiple on one worksheet running at the same time. Some of them stop if you minimize or move to a different worksheet.

    The point of all this is to be able to time several different projects that may start and/or stop at different times.

    January 11th, 2006, 08:04
  • keekooceeaou
    Exporting To Autocad

    I have some data in Excel that I want to export to AutoCAD using VBA Code in Excel. But I don't want to have a table inserted in AutoCAD, but polylines and multitext.
    Is it possible?

    If someone could give me an example, how to draw simple polyline and insert mtext in AutoCAD (from Excel VBA Code) I should be able do do the rest.

    Thanks in advance,

    PS. I think that it would be required to specify insertion point, wouldn't it?
    April 11th, 2007, 17:21
  • tbhendralesmana
    Change font size/type header
    hello, its me again..
    can someone advice me how to change font size and type for header with VBA ?
    currently i used below code for header :

    appreciate any kind of advice :D...
    2 weeks ago
  • tlayrock
    Create a dynamic source data for a pivot table
    I have a workbook with several tabs all with identical layout. I need a pivot table to include all sheets. I have this worked out with Pivot table for multiple consolidated ranges. The problem I have is the number of worksheets changes every week and I have to rebuild the Pivot table, doing this manually takes a great deal of time. I have written some code that works great, I just have to manually code in the worksheet names. I would like to do this all with VBA so that it loops through and gathers all the names and uses that information to create the pivot table.

     For i = 1 To Sheets.Count         If Sheets(i).Visible = True Then             If Trim(Sheets(i).Name) = "Summary" Then             Else                 txt = txt & "Array(" &
    5 days ago
  • sarah1024
    Outlook Saving multiple Attachment with Subject Name
    I got this sample script from Microsoft office website, and it works great in saving attachments from selected e-mail.

    however, I want to include or have just subject of an e-mail as file name, but not sure how to do about it.

    I have tried declaring following variables
    Dim itm As MailItem
    Dim strSubject As String
    strSubject = itm.Subject
    and concatenate strsbject on to attachment path.

    strAtmtPath = strFolderPath & atmt.FileName &strSubject
    but, that didn't work.

    any help is greatly appreciated.

    Option Explicit
    ' *****************
    ' For Outlook 2010.
    ' *****************
    4 days ago