Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.76 seconds.

  1. Re: Macro to pull members from distribution list.

    Is the distribution list located in the default contacts folder?
  2. Re: Macro to pull members from distribution list.

    Did you change the name of the distribution list on this line to the name of your distribution list...


    distListName = "MyDistListName" 'change the name accordingly

    ???
  3. Replies
    13
    Views
    251

    Re: SUMProduct formula error

    Did you check to make sure the ranges are all the same size, as per AhoyNC?

    Also, check to make sure that FTHomegoals and FTAwaygoals do not contain one or more cells that contain text values.
  4. Replies
    4
    Views
    170

    Re: SUMPRODUCT and EXACT problem

    Try...

    =SUMPRODUCT(($A$56:$A$300>=3)*(EXACT(S$56:S$300,Sheet2!$K$2:$R$2)))

    Hope this helps!
  5. Re: VBA Code to send email based on cell not working

    Hi Dante, good catch. ;)
  6. Re: VBA Code to send email based on cell not working

    Can you post the formula you have in M12?
  7. Re: worksheet.vPageBreaks.Count returns zero (0)

    Maybe you mean horizontal page breaks...

    Debug.Print ("Count: " & CStr(Worksheets(2).HPageBreaks.Count))

    ???
  8. Re: Writing a worksheetFunction to the worksheet

    What is the resulting string assigned to Avar?

    Also, does your version of Excel use a semi-colon as a list separator, as per your example? Or does it actually use a comma as a list separator?
  9. Replies
    2
    Views
    60

    Re: Clicking a web page button via VBA

    The getElementsByClassName returns a collection of elements. Therefore, let's say that you want the first element from the collection, try...


    objIE.document.getElementsByClassName("btn...
  10. Re: Adding WindowsMediaPlayer to a form...At runtime.

    You're very welcome, and thanks for the feedback.

    Cheers!
  11. Re: Set focus after tabbing through textboxes and checkboxes on sheet

    Try...


    Private Sub CheckBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If KeyCode = vbKeyTab Then
    With CheckBox2
    .Activate
    ...
  12. Replies
    12
    Views
    140

    Re: Worksheet Loop searching for yellow

    Try the following macro, which has been amended to paste values and formats. Note that ScreenUpdating has been set to False at the beginning of the macro to prevent the screen from updating and...
  13. Replies
    3
    Views
    111

    Re: Saving Specific Sheet With VBA

    You have not included the path to the folder in which you want save your file. In this case, the file gets saved in the current directory. So look there for the file. Also, the file format for a text...
  14. Re: Macro to pull members from distribution list.

    The following macro will first create a new worksheet, and then list the details of the specified distribution list in the newly created worksheet. Change the name of the distribution list...
  15. Replies
    12
    Views
    140

    Re: Worksheet Loop searching for yellow

    Try...


    Option Explicit

    Sub CopyRows()


    Dim destinationWorksheet As Worksheet
    Dim currentWorksheet As Worksheet
  16. Replies
    8
    Views
    185

    Re: Help with index match formula

    It looks like the source data contains dates specified as the first of the month. If so, your lookup value needs to be a date that represents the first day of the specified month. However, if the...
  17. Replies
    12
    Views
    140

    Re: Worksheet Loop searching for yellow

    To check whether a cell contains "XYZ", try...


    If InStr(1, currentCell.Value, "XYZ", vbTextCompare) > 0 Then


    To check whether a cell contains "XYZ" and is highlighted in yellow, try...
  18. Re: Create .csv file from a workbook sheet with new filename and timestamp

    As I mentioned, you should be using the Mac equivalent of the Dir function. Unfortunately, I don't use the Mac, so I can't be of any help to you. So, basically, you need to ensure that you're...
  19. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    I think your solution is much better. It would eliminate the need to store the images within the file itself, which would reduce the size of the file. And, it would eliminate the need to create a...
  20. Replies
    10
    Views
    195

    Re: How to click hyperlink on webpage

    Sorry, I don't see off hand why you're getting an error. Maybe John (or someone else) might be able to pinpoint the problem.
  21. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    It would suggest that the file specified by temporaryFile does not exist. Other than calling ReplaceRectangleImage from another procedure, did you change the code at all?
  22. Re: Create .csv file from a workbook sheet with new filename and timestamp

    Also, you said that you wanted to add a time stamp as well, so maybe something like this...


    MyFileName = "GROWBOTSSS" & Format(Now, "ddmmyy hh-mm-ss")
  23. Re: Create .csv file from a workbook sheet with new filename and timestamp

    Sorry, I re-read your post and see now that you're dealing with a Mac version of Excel. Also, we should have been checking for a valid path, not a valid path and filename. Sorry, my mistake. It...
  24. Re: Create .csv file from a workbook sheet with new filename and timestamp

    First, since your path doesn't specify a drive, it defaults to the current one, which may or may not be what you want. So, if the specified path and filename isn't located in the current drive,...
  25. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    You only need to call ReplaceRectangleImage, which will in turn call the GetReplacementImage and ReplaceImage...


    Sub RunAll()
    Call insert
    Call ReplaceRectangleImage
    End Sub
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4