Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. VBA Chart.SetSourceData suddenly stopped working

    Hi Everyone,

    I have been using this block of code for almost a year without any issues. Today I started getting and error that says "Compile error: Method or data member not found" as soon as the...
  2. Re: Using a macro enabled workbook across different computers

    Thank you again so much for the information!

    This is the process we are using: First, the user downloads a raw data set from a website. Next, the user opens the file containing the macros I've...
  3. Re: Using a macro enabled workbook across different computers

    Hi bobsan42! Thanks for your response!

    I'm using From Controls because all users are on Macs and I'm pretty sure ActiveX isn't supported. The macro creates the buttons and associated subs, so how...
  4. Using a macro enabled workbook across different computers

    Hello All!

    I have a macro that sorts a raw data set and adds a bunch of buttons. Those buttons call methods that search for a specific data set, sort data, or build graphs.

    It all works great...
  5. Replies
    4
    Views
    165

    Re: Excel Limitations for Large Macros

    Than you so much for the reply! I will definitely use the links you provided. Typically, Google has been my go-to but in this case I'm just not sure what to search for. The results are so broad I'm...
  6. Replies
    4
    Views
    165

    Excel Limitations for Large Macros

    Hi All,

    I'll try to make this as brief as possible, but please let me know if I haven't supplied enough info.

    I have a project with approximately 19,000 lines of code (I'm assuming that's large...
  7. Dynamic Chart Ranges based on Drop Down List Selection

    Hi All!

    I have two drop down menus consisting of dates using the Data Validation method. I'm trying to get the X axis to update based off of the input from those drop down menus. For example, if...
  8. Re: Finding Total Duration Based on Multiple Criteria

    Hi!

    1. The formula is in cell H7 on a tab titled "Home". The formula references "RawData" in a separate tab. I've dragged the formula down through cell H500 on the Home tab.

    2. The formula...
  9. Re: Finding Total Duration Based on Multiple Criteria

    We pull reports that download as a CSV. Each data set we download is formatted the same but the range is different. The data set doesn't change often when referencing a single workbook but the data...
  10. Re: Finding Total Duration Based on Multiple Criteria

    Quick question for you again if you're available. I filled about 500 cells with appropriate variations of the formula you came up with. The values are returned correctly and the macro runs smoothly....
  11. Re: Finding Total Duration Based on Multiple Criteria

    Thank you!!! This does the trick! I think I need to develop a better understanding of MATCH, FREQUENCY, AND INDEX functions. Thank you again!
  12. Re: Finding Total Duration Based on Multiple Criteria

    Thank you!!! This works well!!
  13. Re: Finding Total Duration Based on Multiple Criteria

    Sorry, hopefully this data set makes more sense. I'm looking for formulas for G2:G3 below. Thank you!



    <tbody>

    Row/
    Column

    A
  14. Re: Finding Total Duration Based on Multiple Criteria

    Sorry, I'm having a hard time describing my data set. I gave the pivot table a shot but have the same problem. The value in "Sum of Session Length" gives me the sum of all session lengths for each...
  15. Re: Finding Total Duration Based on Multiple Criteria

    No, I'm still looking for the 5:17. If I were to filter my data for 01-May I'd see something like the sample data set I posted. Looking at that I can see several projects were worked on during that...
  16. Re: Finding Total Duration Based on Multiple Criteria

    Thank you for the reply! I haven't worked with SUMPRODUCT and didn't realize how flexible it can be. Unfortunately, I'll have to ignore any references to the project name because the name and number...
  17. Re: Finding Total Duration Based on Multiple Criteria

    Thank you for the reply! Is it possible to do this without referencing the project name? I think that's where I'm struggling. On any given date the name and number of projects will be different so...
  18. Finding Total Duration Based on Multiple Criteria

    Hello all, and Thank You in advance!

    A sample data set is below. I'm trying to write a formula that tells me the total session length for any given date. In the data set below, the output I'm...
  19. Marco error deletes raw data, but only on the first run

    Hi!


    I have two files, one is a CSV raw data set and the other contains my macros. The macros modify the raw data set so that it is readable and adds some tools to the file that help analyze the...
  20. Replies
    5
    Views
    522

    Re: Pasting to Word

    I gave it a shot but still got the same result. The data is in the clipboard but the word document is still blank. I'm really sorry if I'm making obvious missteps. This is my first attempt at...
  21. Replies
    5
    Views
    522

    Re: Pasting to Word

    Thanks for the reply!!

    I gave that a shot but unfortunately had the same result (only a blank word doc opens). I thought maybe I needed to copy the data before the word doc opens and reorganized...
  22. Replies
    5
    Views
    522

    Pasting to Word

    Hello!

    I'm attempting to copy a range from Excel and paste into a blank word document. The following code works up to the point where the pasting should occur. If I run the macro a new word...
  23. Replies
    0
    Views
    92

    Moving Images Without Saving

    Hello All!!!

    I built a macro to process CSV data sets. A website generates the data set and the macro processes them. I'd love to store a copy of the client's logo in macro file and move it to the...
  24. Replies
    8
    Views
    654

    Re: Strange Conditional Formatting Error

    Sure!

    Here was my original code:In VBA:Range("$Q29:$Q1529").Select
    With Range("Q29:Q1529")
    .FormatConditions.Add Type:=xlExpression, Formula1:= _
    "=AND($R29=""Phase 1...
  25. Replies
    8
    Views
    654

    Re: Strange Conditional Formatting Error

    I figured it out! Kinda.

    I'm half a bottle of wine in trying to figure this thing out. I tried replacing the double quotations with the chr(34) code but didn't have any luck. I also replaced all...
Results 1 to 25 of 44
Page 1 of 2 1 2