Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Error: We Cannot Convert a value of Type Function to Type list

    I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I...
  2. Replies
    3
    Views
    73

    Re: Calculation of Net Working days

    WOW! The coding is way over my head!! Also, I want to include holidays.
  3. Replies
    3
    Views
    73

    Calculation of Net Working days

    Is there a way to calculate the number of work days between two days? If so, how? Very new to Power Query...….
  4. Re: Custom or Conditional Column to Copy data to Null Cells

    Yes. I didn't realize it had that functionality. New to Power Query
  5. Re: Custom or Conditional Column to Copy data to Null Cells

    I figured it out. I am trying to make this harder than it needs to be :)
  6. Custom or Conditional Column to Copy data to Null Cells

    I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and...
  7. Replies
    1
    Views
    423

    Delete rows if a condition is not met

    I am just starting to learn to use Power Query. I would like to delete any rows that do not contain "Err" and keep any rows that have no data in a certain column. If I was writing code in a macro,...
  8. Switching Windows with Different File names

    I feel silly asking this but I just cannot figure it out. I have a macro workbook set up with form control buttons to pick the module you would like to run. The issue I am having is getting the...
  9. Re: VBA to copy and paste text from merged cells in a WB to merged cells in another

    Thank you!
  10. VBA to copy and paste text from merged cells in a WB to merged cells in another

    I know working with merged cells can be problematic. I have a workbook and I am trying to copy the text (which will change from month to month) within the merged cells and paste the text into merged...
  11. Re: Creating variables for file path names VBA

    I figured it out. I had a typo in the file path. I am so sorry I wasted for time. I must say I learn so many new things about macros from this site.
  12. Re: Creating variables for file path names VBA

    It is coming up blank :(
  13. Re: Creating variables for file path names VBA

    I entered the number 2. I want the result to be P2 in the file name.
  14. Re: Creating variables for file path names VBA

    I am getting run-time error '1004': Method 'SaveAs' of object'_Workbook' failed.
  15. Re: Creating variables for file path names VBA

    I guess I do not understand what you are asking me. I have a message box popping up asking to enter which period they are working on. Depending on the number entered will determine what PNumber is.
  16. Re: Creating variables for file path names VBA

    PNumber is going to change every month - it stands for period #. Period 2 is May, Period 3 is June, etc.
  17. Re: Creating variables for file path names VBA

    Now I ran into a different problem but it is similar. I think it may have to do with my brackets as the file name has a data that will change each month:

    Coding:

    'Ask user for the period of...
  18. Re: Creating variables for file path names VBA

    Thank everyone!!! I REALLY appreciate!!!
  19. Creating variables for file path names VBA

    I am writing coding for a rather large macro and I am trying to decrease the number of characters I use. One way to do this is to define a variable for the long file path name but it is not liking...
  20. Re: Problems with VBA coding to Create Pivot Tables after upgrade to Excel 2016

    You are a life saver!!!
  21. Problems with VBA coding to Create Pivot Tables after upgrade to Excel 2016

    I am trying to run all my macros to ensure they work since being upgraded to Office 2016. I am getting a "debug" error whenever the coding is trying to create a pivot table. I even recorded the...
  22. Re: Formatting all worksheets in Workbook - Compile Error

    I just figured it out!!!! Thanks anyways!!!
  23. Re: Formatting all worksheets in Workbook - Compile Error

    Ok. This is the only additional coding I have added to this macro so I thought I the error had to be in there. It worked before I added in the coding. Looking closer it is giving me this error...
  24. Formatting all worksheets in Workbook - Compile Error

    I am trying to add some formatting to all worksheets in a workbook but I keep getting compile error: "Expected End With". I cannot seem to find what I am doing wrong.


    'Set up "Comments"...
  25. Adding Conditional Formatting to Pivot tables using a Loop VBA

    I am trying to write VBA coding to add conditional formatting to a pivot table per tab using a loop. The problem I am having is the loop is looking for a pivot table name (like PivotTable22) and tab...
Results 1 to 25 of 114
Page 1 of 5 1 2 3 4