Search:

Type: Posts; User: Arcturus16a; Keyword(s):

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Auto-execute VBA code on workbook open

    I found this sample code but it doesn't want to run when I open the file I added it to. I tried to exit Excel and then reopen the file, but still no luck.

    Private Sub Workbook_Open()
    MsgBox...
  2. Replies
    5
    Views
    204

    Thanks for the solutions. I tried all of them. ...

    Thanks for the solutions. I tried all of them. In the end I'll use Maudibe's solution for expediency, but I want to try to use RetiredGeek's and Rory's in in the future. Maybe something to loop...
  3. Replies
    5
    Views
    204

    Stop VBA when user selects Cancel

    What code can I use to stop VBA from processing when the user selects the Cancel button option in the InputBox?

    Sub RefreshPT()
    '
    ' RefreshPT Macro
    '
    Sheets("Control").Activate
    ...
  4. Replies
    1
    Views
    129

    Macro to create a pivot table

    I have recorded a macro to create a pivot table from data exported from one of our applications. The macro would select the Report Filter, Row Labels and Values. I carefully stepped through my...
  5. Replies
    2
    Views
    218

    How much processing power do I need?

    How much processing power do I need to complete the attached spreadsheet quickly?

    I posted this question in the Excel Forum about a pc's requirements for completing a large Excel spreadsheet.
  6. Replies
    6
    Views
    355

    How much processing power do I need?

    How much processing power do I need to complete the attached spreadsheet quickly?

    There's a workbook attached with 826k+ rows of customer account numbers in column B. In column A I'd like a...
  7. Replies
    7
    Views
    631

    That's It! Perfect. Thanks Mr. Geek. I...

    That's It! Perfect. Thanks Mr. Geek.

    I modified the Filename so that this code can be inserted into any workbook. All a user needs to do (I think) is to change the Sheets Array at the...
  8. Replies
    7
    Views
    631

    A selection of sheets. Originally, I posted ...

    A selection of sheets. Originally, I posted

    Sheets(Array("Sum Regular Hours", "Sum Regular Dollars", "Sum OT Hours", "Sum OT Dollars")).Select

    but have modified the sheet names to exclude the...
  9. Replies
    7
    Views
    631

    No. That didn't help. The PDF ignores the...

    No. That didn't help. The PDF ignores the preselected print ranges and appears to use only A1:A5.
  10. Replies
    7
    Views
    631

    Excel VBA to Save As a PDF

    This macro works for saving & printing the current sheet as a PDF. How can I modify it to save & print a selection?

    Sub Save_to_PDF2()

    ChDir "G:\Payroll_Report\OT&TimeApprovalReport"


    Dim...
  11. That'd be one more reason for me to upgrade...

    That'd be one more reason for me to upgrade Jeremy. I'm on XL 2007 SP3.

    I'll find out soon enough. I just bought a new pc for home use last week and will add MS Office 2013.

    What I'm trying...
  12. Pivot Table - Reveal the Summarized Field Titles

    38856Is there a way to get Pivot Table to display the row labels for the fields it is summarizing?

    Each record in my data begins with four fields: Div #, Div Name, Dept #, and Dept Name.
    ...
  13. Replies
    4
    Views
    419

    Timescale. That's it! When I change the five...

    Timescale. That's it! When I change the five date values to 1-5 I can adjust the Overlap and Gap to display what Steve displays. I'll have to find a workaround to display the dates if I need a...
  14. Replies
    4
    Views
    419

    Width of Columns in Column Chart

    I have made a chart (vertical columns) with only five data points and I would like to widen the columns.

    In Format Data Series - Series Options I have adjusted Overlap to 100% Overlap and Gap...
  15. Replies
    12
    Views
    2,433

    Upgrading from Outlook Express

    I'm running Outlook Express on Windows XP. I plan to purchase a new pc with Windows 8 soon.

    Did MS make a version of Outlook Express for the new Windows?
    If not, what's a good alternative? ...
  16. Format for Pivot Table to Hide the "(blank)" result

    How can I hide the "(blank)" results in a pivot table when the field data are empty?

    I have created a table of results by placing the data fields in only Row Labels. Its a list of customers -...
  17. Replies
    3
    Views
    505

    Trailing 26 Periods for Charting

    I have a table to which I add bi-weekly data in a new row and a chart based on the table which displays the most recent 27 bi-weekly period results. What functions can you suggest I try to get the...
  18. Replies
    4
    Views
    5,890

    Thanks Rory. I've created PT formulas before. ...

    Thanks Rory. I've created PT formulas before. But I've also seen the rows automatically summed.
  19. Replies
    4
    Views
    5,890

    Pivot Table - Grand Total for Rows

    I've got a simple set of data which I want to summarize in a Pivot Table. There are only two fields that I want added together for each record. The Pivot Table sums down the two columns but I can't...
  20. Replies
    2
    Views
    530

    Wow! Thanks RG. That is perfect.

    Wow! Thanks RG. That is perfect.
  21. Replies
    2
    Views
    530

    Custom Number Format for Date

    I am building a pivot table which brings a field called Last Date of Change which in the source data is either blank (for new hires who haven't yet gotten a raise) or displays the last rate change...
  22. Thanks RG for the explanation. Since most of my...

    Thanks RG for the explanation. Since most of my code is simple I think I can declare the variables within the routine (between the Subs). I'll check out that article, too.
  23. Thanks Steve. This works with just Dim...

    Thanks Steve.

    This works with just Dim UserValue as String. What's the Option Explicit for? Seems to work fine without it.
    When I try to it add above the line Sub AddDate2Header(), VBA...
  24. XL Macro to place date in sheet header

    I'm trying to create a macro to get a date, place it in a cell, and then use that date to update certain sheets within the workbook. But I'm getting an error message when the macro gets to user...
  25. That's great! Thanks Maud. I modified it for...

    That's great! Thanks Maud. I modified it for three charts and it works perfectly.
Results 1 to 25 of 316
Page 1 of 13 1 2 3 4