trap

  1. P

    Frequency

    There are several post on FREQUENCY here but I cannot seem to adapt them to my needs. I have several variables that FREQUENCY is tied to and I just cannot make them work. Any help would be greatly appreciated. ~~There are several formulas with frequency on here, but for the life of me I...
  2. M

    Sorting/Combining Text Strings and Numbers

    Hi everyone, I am trying to sort the following data into the combined data following. I can't think of a way to do this and have been stuck for quite a while. Basically the goal is to list the numbers in the first column separated by a space, followed by the unique columns. Any tips...
  3. S

    website information using ie

    Good morning all Im a bit stuck trying to get information from a pasricular website. please see below a page from the website. http://greyhoundbet.racingpost.com/#result-meeting-result/race_id=1015910&track_id=7&r_date=2010-03-12&r_time=11:03 My problem is im trying to obtain the traps...
  4. K

    Get Subject from Email

    Hello All! I have been searching and searching and cannot seem to find something that will help me. Here's the gist of what I'm trying to do: The user will receive an email with a link to an Excel file in it. When the user opens the file, I would like to trap the subject of that particular...
  5. J

    VBA Apply to all sheets in workbook

    Trying to get the code below to apply to all unhidden worksheets, it only appears to apply it to the selected sheet at present. Any ideas please? Many thanks. Public Sub Template() Dim ws As Worksheet Dim strFormulaPart1 As String Dim strFormulaPart2 As String Dim strFormulaPart3 As String...
  6. J

    IFERROR Efficiency...

    This is a technical question about IFERROR. I have a few formulas that depend on particular cells to contain data to function correctly. A lack of any data in those cells will result in an error value. Previously, I trapped these errors using the following method: =IF(ISBLANK(D3),"",formula)...
  7. L

    Help with Error Traps...

    So I have some code (which I'm sure can be written more elegantly, but we all have to start somewhere haha) and I my error statements don't seem to be doing what I was hoping they would do. Basically, my code copies info from bookA.SheetA to bookB.SheetA and I've repeated it so that it does...
  8. M

    Shift Key Excel 2003 VBA

    I know that I can trap the row and cell selected with Target.Row and Target.Column in a BeforeRightClick, Change etc. event but how can I also tell if a shift (shift, alt, ctrl) key is also pressed?

Some videos you may like

This Week's Hot Topics

Top