Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    62

    Re: XML Format Issue

    Im trying to get the XML to read in one continous line rather than having the spacing, not sure how to resolve this
  2. Replies
    6
    Views
    177

    Re: Sort VBA Question

    thanks for help, after restarting the PC the errors seemed to disappear. I'm testing a lot to try repeat the error but it hasn't reoccured
  3. Replies
    2
    Views
    62

    Re: XML Format Issue

    Anyone able to help me?
  4. Replies
    2
    Views
    62

    XML Format Issue

    Hi

    I have an excel macro that is creating an XML but it saving the XML file like this:


    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <funds...
  5. Thread: Outlook Query

    by heffo500
    Replies
    1
    Views
    77

    Re: Outlook Query

    Bump
  6. Thread: Outlook Query

    by heffo500
    Replies
    1
    Views
    77

    Outlook Query

    Hi

    I have the below code that sends an email if tow conditions are met.

    I have two questions:

    Sub email()
    Dim i As Long, lr As Long, scdata As String, myolapp As Object, myitem As Object...
  7. Replies
    6
    Views
    177

    Re: Sort VBA Question

    I see to get a different issue in my code first:

    Sheets("
    Sheet1").Select

    lr = Range("A" & Rows.Count).End(xlUp).Row
    ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add...
  8. Replies
    6
    Views
    177

    Re: Sort VBA Question

    Thanks for the reply the error appears at .Apply

    The error is:

    Run-time error '1004':

    The sort reference is not valid. Make sure that it's within the data you want to sort, and the first...
  9. Replies
    6
    Views
    177

    Sort VBA Question

    Hi

    When I run the below I get an error, it only seems to happen when there is only one row to sort:

    lr2 = Range("D" & Rows.Count).End(xlUp).Row
    Range("D1:N" & lr2).Select
    ...
  10. Replies
    4
    Views
    223

    Re: Active X Issue

    I seem to have figure the issue, the macro works fine when in our share drive but wont work when saved in my local drive.
  11. Replies
    4
    Views
    223

    Re: Active X Issue

    Thanks for the reply, I'm using both macros on my own PC so in one spreadsheet they work fine and in this one I get the active X error. They are both XLSM files.
  12. Replies
    4
    Views
    223

    Active X Issue

    Hi

    I have this macro below which works perfectly takes a section of a sheet coverts to HTML and pastes it into an email.

    However when I imported it into an old spreadsheet with other macros I...
  13. Replies
    1
    Views
    107

    Outlook VBA Search Slowness

    Hi

    I use the below code to save down attachments from our outlook accounts to our shared drive. For me it works perfectly on Windows 10, a colleague was on Windows 7 and it worked perfect for him...
  14. Replies
    1
    Views
    85

    Evaluate(Replace Query

    Hi

    I'm using the below bit of code:

    bk.Sheets(1).Range(addr).Value = Evaluate(Replace("IF(@<>""APPLE"",FALSE,@)", "@", addr))

    addr is the range I'm searching through using xlUp.

    I'm...
  15. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    Thanks so much for the help, its so more efficient than looping.
  16. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    I couldn't it working in the sub with countries filter but when I did the >= 50 filter in a separate it sub its works fine.
  17. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    How I found to get it going was to do the filter for >= 50 in a separate sub and call them together in another sub so they work off a single button. It seems to do with both filters and then its...
  18. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    I think you may right as it will only let me filter as text. the problem I face is that in the column where I want filter greater than or equal to 50 thereis also values N.A. which I need to remain...
  19. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    Yeah those cells are set to general
  20. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    I have the below:

    Application.ScreenUpdating = False
    With ABC.UsedRange
    .AutoFilter Field:=3, Criteria1:=Countries, Operator:=xlFilterValues
    ...
  21. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    Only trouble I seem to have now is the below seems to no long apply:

    .AutoFilter Field:=6, Criteria1:=">=50"
  22. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    That worked perfectly once I added in

    ReDim Countries(1 To 26 - Application.CountBlank(Sheet1.Range("A2:A27")))

    Thanks for much for the help.
  23. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    I can change the formula on the front sheet for the above to work just wondering can I do it on the filter side
  24. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    i got it to work however it seems to be doing the opposite to what I want:

    .AutoFilter Field:=3, Criteria1:=Countries, Operator:=xlFilterValues
    ...
  25. Replies
    23
    Views
    1,082

    Re: VBA Filter Issue

    Any ideas why that still wont work?
Results 1 to 25 of 40
Page 1 of 2 1 2