Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    7
    Views
    476

    Re: Filtering based on arrays

    works great. thank you
  2. Replies
    7
    Views
    476

    Re: Filtering based on arrays

    in the below line i put the list of data into column BX



    Exclude = Range("X2", Range("X" & Rows.Count).End(xlUp)).Value2


    so i changed the code to if that is correct:
  3. Replies
    7
    Views
    476

    Re: Filtering based on arrays

    I might not have been super clear, my bad. but column D can contain anywhere from a few 100 rows to 2000 rows, and possibly more depending on the month. What I need to do is filter out only 7 items...
  4. Replies
    7
    Views
    476

    Filtering based on arrays

    I have a sheet that can contain upwards of 1500-2000 rows. I am trying to get VBA to filter based on certain if criteria matches items pull into an array. Part of my code work perfectly since the...
  5. Re: VBA - add comment to cell that script highlights

    worked perfectly thank you
  6. VBA - add comment to cell that script highlights

    I have a code that highlights the cell if the cell value matches the array and it is working perfectly.
    I was wanting it to also add a comment to the cell it locates from the array and after much...
  7. VBA: goto cell in column A:A that contains date of sunday for curent week.

    I have looked everywhere and unable to locate my answer. is is possible to write some VBA code that would, at the click of a button, go to the cell in Column A that contains the date for Sunday of...
  8. Help - Sending email through VBA with multiple attached files

    I am attempting to use the following code to send an email through outlook from excel with 2 cells and a range of cells as the message body and attach multiple files to the email if they exist on the...
  9. Replies
    8
    Views
    392

    Re: a little vba help

    Validated several times that the cells i want cleared are unlocked and it does not roll through the sheets to clear out the unlocked cells on all the sheets in the work book. I did find code that...
  10. Replies
    8
    Views
    392

    Re: a little vba help

    This runs fast and keeps the hyperlinks intact but it doesnt clear any of the unlocked cells.
  11. Replies
    8
    Views
    392

    Re: a little vba help

    I have not tested his but i did find some code that works but it is CRAZY slow...



    Dim ws As Worksheet
    For Each ws In Worksheets
    With ws
    For Each C In .UsedRange
    If C.Locked = False Then...
  12. Replies
    8
    Views
    392

    Re: a little vba help

    yes they are locked
  13. Replies
    8
    Views
    392

    a little vba help

    i am using the following to clear all unlocked cells in multiple sheets of a workbook.


    Dim wks As Worksheet

    For Each wks In ThisWorkbook.Worksheets
    On Error Resume Next
    ...
Results 1 to 13 of 13