trap

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...

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...

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...

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...

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...

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)...

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...

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?