Announcement

Collapse
No announcement yet.

Forums

Collapse
  • 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
Sub-Forums:
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
Sub-Forums:
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
Sub-Forums:
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
Carim
Knitting patterns
by Carim
Sub-Forums:
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?

Collapse

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

Collapse

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

Welcome to OzGrid!

Collapse

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

Collapse

  • madz1101
    VBA code errors
    madz1101
    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
    hightester
    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.
    tbhendralesmana
    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

Collapse

There are no results that meet this criteria.

Trending on OzGrid

Collapse

  • rdblatch
    Multiple timers (stopwatches) in one worksheet
    rdblatch
    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.

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

    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,
    Paul

    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
    tbhendralesmana
    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
    tlayrock
    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.

    Code:
     
     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
    sarah1024
    I got this sample script from Microsoft office website, and it works great in saving attachments from selected e-mail.
    https://gallery.technet.microsoft.co.../Discussions/4

    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
    Code:
    Dim itm As MailItem
    Dim strSubject As String
    
    strSubject = itm.Subject
    and concatenate strsbject on to attachment path.

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

    any help is greatly appreciated.


    Code:
    Option Explicit
    
    
    ' *****************
    ' For Outlook 2010.
    ' *****************
    ...
    4 days ago
Working...
X