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?

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top