double

Hi, When I am passing a range to the below UDF, say A1=CorrelationCoefficient(B1:C100, 1, 2, 0) I am getting an VALUE error. Any reason why? The code is: Public Function CorrelationCoefficient(MyArray() As Double, Optional asX As Long = -1, _ Optional...

I have cell K8 with color fill yellow and I'm using the code below so that it became a no fill cell when double click on it. I think that I have something wrong in the code since its not functioning. Thanks Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target...

Hi! I am trying to return the size of a selection, when I specify the type and output required, which may not match the exact output, and therefore needs to find the closest match, for a certain type. <tbody> A B C D E F 1 Type Output Size Type Single 2 Single 200 300 Output 175 3...

Hello! I'm writing a macro and I keep getting an overflow error. At first I believed it was because I was using Integer and the value was too large for that data type. But I've tried Long and Double to the same error. What am I missing? Values being used; material = 35000 txtWT = .5 txtDia =...

Hello, I am trying to have an entire row get deleted if the user double clicks a cell anywhere in column B. Column B is a Description column, so if the user double clicks that particular description it will delete the entire row and shift everything below it up so there are no blank rows. Here...

Hello, I have an issue that i cant get my head around. I have a formula on a sheet: =AD504/AD503 which returns #Div/0! However if i use the following vba i get an answer... Sub hjklasdfasdfad() Dim V1 As Double, V2 As Double V1 = ActiveSheet.Range("AD503").Value V2 =...

So I used to work with a co-worker who used this excel macro to do his daily checklist and he sent it to me a long time ago. I never had the need to use it till now, when you double left click it timestamps the cell with the initials of your logon username and the date which is perfect for my...

Hello all, To begin here is the DropBox link to the exact work book I am talking about here https://www.dropbox.com/sh/dunqarfm89unhbu/AABMkvpgW6HYXBrOry2qpXPTa?dl=0 I have a question Regarding the Worksheet double click event. If you go to Sheet "Finish List" Notice there are three items on...

I am trying to generate Pearson's Correlation Matrix; and subsequently Spearman's. When I use the Excel's in-built Correl function, I get the output. But, when I use my custom function for correl, I get a VALUE# error. That is, if I replace "Application.WorksheetFunction.Correl" with...

Hi, I have a macro that generates PowerPoint slides which a bunch of different things from Excel. I have a total of about 50 Slides to generate, often at around 20 slides the code will crash and give a runtime error. When it crashes its always got something to do with this section of the code...

I have a pivot table connected to a SSAS Cube. The Field List shows all the columns from the table. When double clicking a cell the detail sheet is not showing all the columns in the table. Is there configuration to show all the columns in the detail table. Is this by design show only few...

OK - Not sure if that title even explains it properly... I have a questionnaire which asks several questions about a certain topic, and then later on a "double check" single question and I want to set up a formula to check if the answers in the first section are in line with what they answer in...

Hello. I use a LaserJet 1320 (OK, its old, but it is robust and works), and I have to print quite long spreadsheets at regular intervals. Currently I use "Activewindow.selectedsheets.printout From:=1, to:=Printpages, copies:=copyno, Collate:=true, Ignoreprintareas:=false". Is there a way...

This is driving me bonkers. I don't think I've ever had this issue before but... I have a function that takes several ranges from a spreadsheet and calculates a spline curve from them. The mechanics aren't important. Because this thing is having trouble in a REALLY WEIRD WAY. The function is...

Hi can anyone help? I have a form button that when clicked adds rows of data to sheet1. Is it possible to have this button add the rows with a single click as it does now but if double clicked add some text in cell A1 ie "ABC" without adding the rows at the same time? any help would be...

I want to kniw that how can we prevent double data entry in more than one sheet. If i want to know double name or mob8le no. Is entered twice, i aleays visit next sheet to cinfirm. Plz help

https://app.box.com/s/3ak713qk5hg9xdklyzl4plimyp4xjthf Need a formula in columns L25:BW25 to count the number of hits for each 3 values in L1:BW1. The existing formula does not recognize double or triple numbers.

Hey all, I needsome help and not sure where else to turn. Tried searching for an answer to my problembut couldn't find anything. So whatI'm trying to do is, in a single spreadsheet, when I double click a specificcell in column J it will copy the content into a cell in column A. What I...

I am trying to get the value of a column frm the same row as I double click to be placed in the cell I am clicking. Have managed to produce an offset value but how can I make it choose a value from the column? Thanks in advance

Hi, I need help with getting a rather complex double if/and formula working correctly. I am stumped. In the attached spreadsheet we are looking at cell AA157. In the formulas I am setting up requirements using the if & and formulas together that say the job numbers in cells U157 & B157 must...