Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    28
    Views
    767

    Re: Looping is killing my Excel 365 VBA code!

    Can you tell me if anyone is able to run/test your macro without your docx file ?
  2. Re: Can I make my VBA trigger automatically off a cell updated from a DDE link?

    I copy your posted code into a single module and without Option Explicit the only compile error I get is
    Ambiguous name detected: OpenRSLinx
    which is due to functions with the same name.

    I...
  3. Re: Can I make my VBA trigger automatically off a cell updated from a DDE link?

    Could be that your original post has Private Function OpenRSLinx() so will only be availabe to procedures in the same module,
    where as a Public Function OpenRSLinx() will be available to all...
  4. Re: Can I make my VBA trigger automatically off a cell updated from a DDE link?

    Don't know RSLinx so don't know what you've got there that triggers automatically but hey, if you're happy, I'm happy.
  5. Re: Can I make my VBA trigger automatically off a cell updated from a DDE link?

    Not sure I understand any of your answers, but anyway assuming A1 is the cell to monitor for change, try this.
    Copy A1 and paste it as values to a cell somewhere out of the way, say Z1.
    Right click...
  6. Re: Can I make my VBA trigger automatically off a cell updated from a DDE link?

    what cell are you using for this ?
    it has a formula in it, right ?
    when do you want it to trigger, 0 to 1, or 1 to 0, or both ?
  7. Replies
    36
    Views
    838

    Re: Sort table column left to right

    What if you put a dot in front of the other use of Range in that line ?
  8. Replies
    36
    Views
    838

    Re: Sort table column left to right

    Only difference I can see would be the sheet that's active at the time.
    Any use of Range without the dot will refer to the active sheet.
    Using .Range inside the With will refer to whatever the with...
  9. Replies
    36
    Views
    838

    Re: Sort table column left to right

    How did you check this ?
    The Name Manager will indicate what you want, but
    did you type the name into the name box on the formula bar and see the result that's selected ?
  10. Replies
    36
    Views
    838

    Re: Sort table column left to right

    Select G5 and go down the column using the down arrow.
    Anything merged ?

    Did you see my response at your other thread and try it to see what Excel is seeing as the range ?
  11. Replies
    36
    Views
    838

    Re: Sort table column left to right

    You talk 3000 rows but based on the file I have, the 'groups' of 50 rows on the Competitor Comparison Data sheet goes to row 2452.
    40 rows have data and 2407 rows are blank, 47 of those blank rows...
  12. Replies
    28
    Views
    767

    Re: Looping is killing my Excel 365 VBA code!

    range("P31") ??
    range("O1") ??
    wDoc.Tables(1) ??
    wDoc.Tables(2) ??


    Good luck with your project.
  13. Re: Dynamic Range that expands with new columns

    Can't be done.
    A named range needs an address and that would be fixed not dynamic.
    A dynamic named range needs a formula and your sheet layout defeats that.

    With the workbook I've got, I believe...
  14. Replies
    28
    Views
    767

    Re: Looping is killing my Excel 365 VBA code!

    Copied that to a sheet, copied the macro to a module and can't get past the first Dim statement so I'm out.
  15. Replies
    28
    Views
    767

    Re: Looping is killing my Excel 365 VBA code!

    The first line in Norie's reply of post 6 tells you why you're not getting assistance with this.
  16. Replies
    41
    Views
    12,833

    Re: Userform Checkboxes - Select All/Unselect

    It doesn't save anything.
    It starts all over from square one every time the form is activated.
    The headers (D7 to AN7) populate the array and are used for the check boxes captions.
    Whether the...
  17. Replies
    41
    Views
    12,833

    Re: Userform Checkboxes - Select All/Unselect

    Staying with the code of post 24
    try changing userform activate to


    Private Sub UserForm_Activate()
    Dim arr As Variant
    Dim i As Long
    arr = Application.Transpose(Range("D7:AN7").Value)...
  18. Replies
    4
    Views
    139

    Re: How to Add Date Picker To VBA UserForm

    Maybe check out https://trevoreyre.com/portfolio/excel-datepicker/ for a bit different approach.
  19. Replies
    36
    Views
    838

    Re: Sort table column left to right

    CountA counts cells that aren't empty, so guessing the 3000 rows you're wanting to use are mostly blank records.
    Dynamic ?? Didn't you kill that with the merged cells in column D ?
  20. Replies
    36
    Views
    838

    Re: Sort table column left to right

    Exactly.
    In my mind you should be looking into making your raw data a proper Excel Table so you only have one thing to maintain,
    and can use filtering to extract anything you want for coping to...
  21. Replies
    36
    Views
    838

    Re: Sort table column left to right

    In that case then, isn't it conceivable that the CompComparisonTable not even exist ?
    Being totally derived from the "Competitor Comparison Data" sheet couldn't that sheet be filtered and copied to...
  22. Replies
    36
    Views
    838

    Re: Sort table column left to right

    How is the "Competitor Comparison Data" sheet populated ?
  23. Replies
    36
    Views
    838

    Re: Sort table column left to right

    Here's what I was playing around with at the time you were planning to abandon this.

    I didn't know what the actual vba requirement would be for the horizontal sort so used the macro recorder to...
  24. Re: Maintain cell value of referenced cell after sorting

    You're welcome, glad I could be of assistance.
  25. Re: TextBox dependent Unique ID (Count through multiple tables)

    You're welcome, glad I could be of assistance.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4