Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.42 seconds.

  1. Re: Let PowerQueries don't have time to finish with VBA

    There may be a way to do it with some Query property - but I don't use them often, so I don't know.
    But a general pause can be done using Application.Wait.

    So, after your first query, you can do ...
  2. Re: Macro runs in some computers, in others not...

    Are they using the same version of Excel as you are? You're specifying Excel 2016, I believe.
    Also, does the SourceData exist? Does the Destination?
    Finally - is there another pivot table named...
  3. Re: VBA code to copy data from tables on different worksheets and put them in one table

    There are many existing example of this at the board if you do a search. Like this one:...
  4. Re: anybody online who knows vba, offset, and subtotals?

    ah - taking questions off the forum (email, private messaging) is against the rules. We have tools to post sections of data (see my signature about attachment work around) or you can post a link to...
  5. Re: anybody online who knows vba, offset, and subtotals?

    There is no "chat" option with this forum. You can post your question to General Discussions, or if you have a more specific question, to Excel Questions. But the lounge here is for non-Office...
  6. Re: Complex conditional formatting for duplicate values per date of service per client

    owellwell, attachments (and taking questions off the forum) are not allowed, but there are tools you can use, like Oscar did, to post pieces of your sheet. Please refer to the link (Attachments work...
  7. Thread: error 53 handler

    by starl
    Replies
    3
    Views
    171

    Re: error 53 handler

    I'd do it at the very beginning, before the error handler

    the following is untested


    If Len(Dir$(filePath, 16)) > 0 then
    'folder exists; or if you're checking for the file, change the...
  8. Thread: error 53 handler

    by starl
    Replies
    3
    Views
    171

    Re: error 53 handler

    You can use the DIR function to check for the existence of a folder or specific file. Mix it with the LEN function and if the returned value is greater than 0, then the file or folder exists
    ...
  9. Replies
    4
    Views
    990

    Re: I have come out from the shadows

    Hi Confused, I agree - there are some great solutions here and I've kept a few myself. But what you can do is go to 'Thread Tools' at the top of the first post and Subscribe to the thread. I put my...
  10. Replies
    7
    Views
    306

    Re: Multi-sheet Pivot Table

    Glad to help!
    I just wish Consolidated tables option would just merge the data together into a single table, instead of that summary like setup.
  11. Replies
    7
    Views
    306

    Re: Multi-sheet Pivot Table

    So I did understand you correctly? :-) I wasn't too sure.
  12. Replies
    7
    Views
    306

    Re: Multi-sheet Pivot Table

    If I understand you correctly, you'll need to change your tables so the Category column is the leftmost column on all the sheets, then recreate your pivot table.
  13. Replies
    7
    Views
    306

    Re: Multi-sheet Pivot Table

    If the sheets are the same, you can Consolidate the data.
    See: http://www.contextures.com/xlPivot08.html

    Basically, you need to use the original Pivot Table wizard which can only be accessed with...
  14. Re: If Chip Pearson's website ever helped you, please jot a note...

    My condolences to Chip's parents. As you can see, your wonderful son touched the lives of many, MANY people around the world. He shared his knowledge freely and it was truly helpful. He will be...
  15. Replies
    3
    Views
    699

    Re: Thread / Index Icons

    :rofl:
  16. Replies
    3
    Views
    699

    Re: Thread / Index Icons

    At the bottom of each forum's page, there is an Icon Legend.
  17. Replies
    1
    Views
    735

    Re: VBA and Macros for Microsoft Excel

    The link for downloading the sample files can be found at the end of the Introduction, under the heading Code Files.
  18. Re: MoveAfterReturn does not function on protected sheet

    Why not use Events?
  19. Replies
    10
    Views
    646

    Re: prevent copy sheet within a workbook

    I thought I was going nuts! I'm reading the first post and thinking - I don't remember this at all!! Even the post I'm after doesn't seem the same..
    LFKim2018: based on the additional information -...
  20. Re: MoveAfterReturn does not function on protected sheet

    Why does a specific cell need to be active for code to work? If you need to read/write a cell, you can specify it - not use Selection or ActiveCell.

    Anyway, I tested the code and MoveAfterReturn...
  21. Re: Excel 2016 for Mac - How to show the VBA code of a Button

    That option (like many others) doesn't exist on Macs. You have to do it other ways.
    1. go into the VBE and just look for the code
    2. Right-click on the control, select Assign Macro, Edit (if there...
  22. Replies
    6
    Views
    1,083

    Re: No Option to MARK issues as RESOLVED

    And don't think because there's an answer you might not have a better solution, especially for a specific scenario. The number of times an OP left out a crucial bit because s/he didn't think it was...
  23. Replies
    2
    Views
    366

    Re: VBA Code Translator

    This is mainly a recorded macro. I clarified the first instance of a line (for example going to a sheet), but after that, I didn't clarify




    Sub AutoAllocation()

    'pop up message box
    If...
  24. Replies
    6
    Views
    3,203

    Re: Excel VBA to create Powerpoint File

    hey mole - I forgot, when trying to fix the thread, i removed some code.. i just put it back. it's that double less than in step 3....
  25. Replies
    6
    Views
    3,203

    Re: Excel VBA to create Powerpoint File

    I don't know why, but the code tags were causing the window to cut your code off, so I removed the tags.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4