Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 3.51 seconds.

  1. Replies
    4
    Views
    270

    Re: Excel VBA - Transpose???

    Thanks westconn, that works.
  2. Replies
    4
    Views
    270

    Re: Excel VBA - Transpose???

    No I don't. The actual range however is longer and I want to avoid code like this

    For lngRow = 1 to 50
    MyString= MyString & Cells(lngRow, "A")
    Next
  3. Replies
    4
    Views
    270

    [RESOLVED] Excel VBA - Transpose???

    If I have 9 in cell A1, 8 in cell A2 and 7 in cell A3, is it possible to create a string with the value "987" without looping?
  4. Re: Excel: Get Holidays from opm.oov using html

    Thanks. I'm going to use the formula approach you pointed out.
  5. Re: Excel: Get Holidays from opm.oov using html

    That's true but I'm willing to risk that. And thanks for the link. I may use it.
  6. [RESOLVED] Excel: Get Holidays from opm.oov using html

    The opm.gov website has list of US federal holidays that I would like to import into Excel. I know that I should be able to use the 'From Web' button on the Data tab, but I have a very old browser...
  7. Replies
    2
    Views
    247

    Re: MZTOOLS in Excel

    No, since it works in VB6 so shouldn't it work in Excel. Excel's Add-In Manager shows me this
    179609
    while VB6's shows me this.
    179610
  8. Replies
    2
    Views
    247

    MZTOOLS in Excel

    I have an old XP machine and on it are both VB6 and Excel 2010. I used to use MZTOOLS 3.0 in both of them but I had a problem with Excel and MZTOOLS no longer appears in the Add-In Manager. How do I...
  9. Replies
    4
    Views
    269

    Re: Windows 10 Pro License key

    Thanks but mu "latest" version is XP, and because of a problem I don't even have that any more.
  10. Replies
    4
    Views
    269

    Windows 10 Pro License key

    I just had Windows 10 installed via an ISO file. What is the best way to get a license key?
  11. Replies
    1
    Views
    283

    Re: Excel copy after probem

    The workbooks need to be visible which they weren't. After that it's simple.


    For Each ws In wbSource.Worksheets
    If Left(ws.Name, 3) = "tab" Then
    ws.Copy...
  12. Replies
    1
    Views
    283

    [RESOLVED] Excel copy after probem

    I have some code which opens a source workbook and assigns it to a wbSource object and opens a destination workbook and assigns it to a wbDest object.

    My aim is then to copy some of the sheets...
  13. Speed up and improve Google Translate code

    I have the following code which is used to translate the text in a worksheet's cells from any language to English. It is called from a For-Each-cell loop. It works most of the time but once in a...
  14. Replies
    0
    Views
    291

    Using Google Translate

    I have a worksheet that contains random words and phrases in several non-English languages, plus dates and numbers. The "Translate" sub in this code which I found on the web drives the process of...
  15. Replies
    3
    Views
    872

    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?
  16. Findfiltered data in another filtered column

    Ignore - sorry.
  17. 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...
  18. Replies
    13
    Views
    1,132

    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...
  19. 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...
  20. Replies
    13
    Views
    1,132

    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,
  21. Replies
    13
    Views
    1,132

    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...
  22. Replies
    13
    Views
    1,132

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

    Please see my "That's not true" comment.
  23. Replies
    13
    Views
    1,132

    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...
  24. Replies
    13
    Views
    1,132

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

    Thanks but that didn't help.
  25. Replies
    13
    Views
    1,132

    [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...
  26. 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.
  27. 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...
  28. Re: [RESOLVED] "Reset" a With/End With structure?

    I found a workaround.
  29. Replies
    0
    Views
    319

    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...
  30. 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...
  31. [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...
  32. Replies
    4
    Views
    831

    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...
  33. Replies
    1
    Views
    453

    Re: [RESOLVED] Problem with number format.

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

    [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...
  35. Replies
    4
    Views
    680

    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
  36. Replies
    4
    Views
    680

    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
    ...
  37. Replies
    1
    Views
    355

    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...
  38. Replies
    6
    Views
    785

    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.
  39. Replies
    6
    Views
    785

    Re: Don't scale when printing

    What do you mean?
  40. Replies
    6
    Views
    785

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width