Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 7.16 seconds.

  1. Replies
    3
    Views
    716

    Mac to Mac home network video

    Strange question i know, but is it possible for my wife and I to have a video chat between ourselves on our macs over our home network?
  2. Findfiltered data in another filtered column

    Ignore - sorry.
  3. MsOf10 [RESOLVED] Why does filtering work only once?

    In my code I'm filtering on column "X". In the code below column 'X' is represented by COL_CONCAT. If I open the workbook and run the code it works as expected but if I try it again it doesn't and I...
  4. Replies
    13
    Views
    858

    Re: [RESOLVED] $%%$$%# Personal.xlsb

    I believe I found the solution and it's kind of embarrassing but I think I owe it to the people who tried to help me and explain what the problem was.

    As I mentioned above I've worked with Excel...
  5. Re: [RESOLVED] "Reset" a With/End With structure?

    Thanks but I don't think I can do either of those things because of my For lngRow/Next loop. As I said I have a workaround that I don't want to change, but I'll actually test your suggestions when I...
  6. Replies
    13
    Views
    858

    Re: $%%$$%# Personal.xlsb

    Impractical.
    Absolutely. As I said, I was recording macros (and looking for then) for over 10 years until I manually created my first Personal.xlsb file,
  7. Replies
    13
    Views
    858

    Re: $%%$$%# Personal.xlsb

    jdc2000 your other 3 links talk about deleting it but I already did that. After that it comes back when I record a macro. I'm guessing now that there's some registry setting I set to "On" when I...
  8. Replies
    13
    Views
    858

    Re: $%%$$%# Personal.xlsb

    Please see my "That's not true" comment.
  9. Replies
    13
    Views
    858

    Re: $%%$$%# Personal.xlsb

    That's not True. For 10+ years I recorded macros and they always recorded in the current workbook and Personal.xlsb was not in my VBAProject window.

    What didn't work was clicking 'Hide' as...
  10. Replies
    13
    Views
    858

    Re: $%%$$%# Personal.xlsb

    Thanks but that didn't help.
  11. Replies
    13
    Views
    858

    [RESOLVED] $%%$$%# Personal.xlsb

    As an experiment I created a Personal.xlsb file for myself to see what it was like using one. I wasn't happy with the results so I deleted it. After that it doesn't show up in my VBAProject window...
  12. Re: [RESOLVED] "Reset" a With/End With structure?

    Understood and that's the first thing I thought of but there's a lot of code in my actual sub that refers to the same worksheet and I believe that using the ws object is a lot more efficient.
  13. Re: [RESOLVED] "Reset" a With/End With structure?

    I guess I deserve that:)

    I assume (and hope) you can tell that the code that I originally posted is not my actual code but just a simplified example. In any case when the equivalent of lngRow...
  14. Re: [RESOLVED] "Reset" a With/End With structure?

    I found a workaround.
  15. Replies
    0
    Views
    261

    Flickering Mouse Pointer

    I'm hoping someone can help me with this annoying little problem. I have a shape in Excel 2010 that has a macro assigned to it and recently the mouse pointer has started to flicker when I simply...
  16. Re: "Reset" a With/End With structure?

    You can see similar behavior in loops. For example the output of this code

    Sub test()
    Dim lngLastRow As Long
    Dim lngRow As Long
    Dim ctr As Integer

    lngLastRow = 10

    For lngRow = 1 To...
  17. [RESOLVED] "Reset" a With/End With structure?

    I don't think it's possible to do, but I have code that has this structure.


    Set ws = Activesheet
    With ws
    For lngRow = 2 to 1000
    If lngRow = 100
    'Code to create a new...
  18. Replies
    4
    Views
    714

    Range extender for Xfinity router

    In my house we have computers in two rooms at the opposite sides of the house. My computer has the router (from Xfinity) and the my wife's computer is in a room about 35 feet away that we use for an...
  19. Replies
    1
    Views
    373

    Re: [RESOLVED] Problem with number format.

    I fixed it. I found that under the Advanced options, 'Using system separators' was not checked.
  20. Replies
    1
    Views
    373

    [RESOLVED] Problem with number format.

    I have one workbook which all of a sudden started showing numbers displayed as 254-789 rather than 254,789. My default language is English and my regional setting is English (United States). When I...
  21. Replies
    4
    Views
    507

    Re: Return Word wdDialogEditFind options

    Thanks but what I'm looking for is a way to capture the fact that 'Match Case' (and possibly other options) was chosen in this dialog.
    178025
  22. Replies
    4
    Views
    507

    Return Word wdDialogEditFind options

    This code wiill display the Word Find dialog. How do I find out which options the user selected?


    Sub d()
    Dim dlgFind As Dialog

    Set dlgFind = Dialogs(wdDialogEditFind)

    With dlgFind
    ...
  23. Replies
    1
    Views
    298

    Printer Problem

    I have an Epson XP-6100 Series printer and every time I print from Excel it always prints double-sided even if there is only one cell to print. It does not do that when printing from any other...
  24. Replies
    6
    Views
    646

    Re: Don't scale when printing

    Thank you for the suggestion. It turns out that my workbook was corrupted and had several print areas that I couldn't remove or repair and I had to rebuild the workbook.
  25. Replies
    6
    Views
    646

    Re: Don't scale when printing

    What do you mean?
  26. Replies
    6
    Views
    646

    Re: Don't scale when printing

    My zoom is 100%. The problem is that the total width of the 5 columns is less that a full page width so Excel scales up the width to fit the width of 1 page. I think that if I hide the columns to the...
  27. Replies
    6
    Views
    646

    [RESOLVED] Don't scale when printing

    If I were to guess I'd say this isn't possible but what I'd like to be able to do is to print the first 5 columns of my worksheet and have them not scale bigger. In my code I've set the print area...
  28. Replies
    9
    Views
    835

    Re: Problem with USB keyboard

    Yes, Other devices work from the hub.
  29. Replies
    9
    Views
    835

    Re: Problem with USB keyboard

    This sounds like an Apple problem - I phoned them; no joy.
    Apple keyboard - yes.
    plug the peripherals into the hub first, and then plug the hub into the computer - I'll try that later
  30. Replies
    9
    Views
    835

    Re: Problem with USB keyboard

    The hub is powered, and no, unplugging everything else from the hub doesn't help. By the way this is a new hub that I bought thinking that my previous one was the problem.
  31. Replies
    9
    Views
    835

    Problem with USB keyboard

    I use an iMAC and I've noticed that when my keyboard is plugged directly into the back of the mac, the OS recognizes it, but if I plug into into a USB hub (which is plugged into the back of the mac),...
  32. Replies
    14
    Views
    688

    Re: Simulate ListView Click event

    Thanks you for your help. I've just realized that there is a different process in my workbook that selects a listitem and it turns the listitem blue so I just need to find out why this new process...
  33. Replies
    14
    Views
    688

    Re: Simulate ListView Click event

    MyLV.ListItems(3).Selected = True
    Call MyLV_Click()I had done exactly that and it made no difference.
  34. Replies
    14
    Views
    688

    Re: Simulate ListView Click event

    When I manually click an item in the listview it turns blue and my goal is to have the same thing happen when I select it via code.

    "Not sure why "the Click event has no parameters" is relevant"....
  35. Replies
    14
    Views
    688

    Re: Simulate ListView Click event

    Thanks but the Click event has no parameters and in any case there's already a bunch of stuff in it that I don't want executed again. Also, the highlighting is done by the by the listview itself...
  36. Replies
    14
    Views
    688

    Re: Simulate ListView Click event

    MyLV.ListItems(3).Selected = True does not call that event, but if I add this as a nw line after that

    Call MyLV_ItemClick(.ListItems(3))
    it is called but it does not affect the outcome (the...
  37. Replies
    14
    Views
    688

    Re: Simulate ListView Click event

    MyLV.ListItems(3).Selected = True does not call that event, but if I add this as a new line after that

    Call MyLV_ItemClick(.ListItems(3))
    it is called but it does not affect the outcome (the...
  38. Replies
    14
    Views
    688

    Simulate ListView Click event

    I have a listview on a userform in Excel with these properties set in the userform's Initialize event.


    MyLV.View = lvwReport
    MyLV.FullRowSelect = True
    MyLV..HideSelection = False
    ...
  39. Replies
    2
    Views
    315

    Re: Nesting formulas

    Thanks!
  40. Replies
    2
    Views
    315

    [RESOLVED] Nesting formulas

    I have this simple formula
    =SUM(F3:F8)

    and I'd like to replace the 8 with this.
    =COUNT(F1:F9999)-1

    How do I do that?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width