Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    207

    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.
  2. Replies
    4
    Views
    207

    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.
  3. Replies
    4
    Views
    207

    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...
  4. Replies
    1
    Views
    92

    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...
  5. Replies
    1
    Views
    72

    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...
  6. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    Thanks so much for the help, its so more efficient than looping.
  7. Replies
    23
    Views
    976

    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.
  8. Replies
    23
    Views
    976

    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...
  9. Replies
    23
    Views
    976

    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...
  10. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    Yeah those cells are set to general
  11. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    I have the below:

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

    Re: VBA Filter Issue

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

    .AutoFilter Field:=6, Criteria1:=">=50"
  13. Replies
    23
    Views
    976

    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.
  14. Replies
    23
    Views
    976

    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
  15. Replies
    23
    Views
    976

    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
    ...
  16. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    Any ideas why that still wont work?
  17. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    Thanks for that I tried it but it still doesn't filter the Countries, I can see it does pull in them from the in the loop but it doesn't seem to apply that as the filter.

    I have option explicit on...
  18. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    Apologies:

    A B C D

    <colgroup><col><col><col span="2"></colgroup><tbody>
    CE
    Country / Market
    Apply Filter
    CE
  19. Replies
    23
    Views
    976

    Re: VBA Filter Issue

    I have them listed on sheet1

    Country Filter
    Argentina Y
    Brazil Y
    Mexico

    Thanks
  20. Replies
    23
    Views
    976

    VBA Filter Issue

    Hi

    I'm trying to filter using the below:

    Sub Del_Rows()


    Dim Countries As String
    Set wk = ThisWorkbook
    Set ABC = wk.Sheets("123")
  21. Thread: Range.Formula

    by heffo500
    Replies
    2
    Views
    63

    Range.Formula

    Hi

    I am having issue with me code below it inserts the code into all the cells except cell U2, Can anybody tell me where I am going wrong?

    Range("R2").Formula =...
  22. Replies
    1
    Views
    725

    Outlook Meeting Macro

    Hi

    I have never used VBA for Outlook before and was wondering would this be possible.

    I am looking to try schedule a macro to book a specific meeting room on specific days due to current...
  23. Replies
    6
    Views
    119

    Re: VBA Macro Improvement

    Thanks very much really appreciate it.
  24. Replies
    6
    Views
    119

    Re: VBA Macro Improvement

    Apologies It does work. I was playing with it to try copy columns 2-4 but to no avail.
  25. Replies
    6
    Views
    119

    Re: VBA Macro Improvement

    So how would I extend this to the third column?
Results 1 to 25 of 31
Page 1 of 2 1 2