double

I'm gonna search for Country Code for the criteria below: https://zapodaj.net/2f9592ebe0b99.jpg.html I do not know how to use neither double vlookup nor index-match. Can You please create both formulas and explain shortly how it works? Thx in advance. ;)

Is it possible to have several different formulas of conditional formatting in a cell, but they will not occur until the cell is double-clicked? Thank you!

Dear all I am trying to find the minimum value in the array Stress(i,j) The maximum value appears correct. However the minimum value always appears zero if all the elements are positive. Kindly help I am posting the code below Private Sub CommandButton1_Click() Dim i As Integer Dim...

I'm going batty here. I have a large set of records where I have a 14 digit number, that comes over as scientific. I need to have it display the entire number, but it has to be formatted as text. If I double click in the cell (activate it), I get what I need. I can't do that with the size of...

I have the following vba code in a worksheet that when you double click on say the 5th row under the 4th column (D) it deletes everything in that row from the 3rd column (C) to the 1st column (A) and then cuts and pastes the person’s name in the 1st column (A) onto another sheet. Works...

Hi, I am trying to recreate a spreadsheet based on one I have been given. However, I am trying to ensure I understand the coding properly, I don't want to just cut and paste. I am also making some changes, hence another reason why I don't simply want to do this. The spreadsheet is based...

Hey Everyone, I have been working on a function to linear interpolate some data- I got it to where it was giving values however they seem to be incorrect. I cant find an error in the equation so far so i am not sure where to fix things. I am also extremely new to VBA to bear with me on the...

Good afternoon all, I'm struggling with a double donut chart. I know exactly how I want it to look in my head, but when I create it on Excel, it doesn't look the same! I have a number of products, in a number of regions. For instance: Product A has 10 in Region 1, 10 in Region 2 and 0 in...

I will start off by apologizing for the length of this post. The macro is supposed to take the data from an excel file and convert it into a text file script macro for Draftsight. Everything works as intended except for the trig calculation and I believe it is due to a programmatic error. I...

I want to double click on a row, application.workbook.worksheet(1).range ("A1"). When I double click on it it shows a pop out a userform Thank you in advance

Hi, I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such: <tbody> A B C D E F G H I J K L M N 1 Name Job# Loc 6/25 6/26 6/27 6/28 6/29 6/30 7/1 7/2 7/3 7/4 7/5 2 John A X34 USA D D D D D D D D D 3 Joe V45 CAN N...

I am writing a VBA script to integrate over an interval in Excel. I have begun with a simple position and velocity formula to test my code then expanded on it. Unfortunately, it is not working properly as the outcome I am recieving is .044 while the expected outcome using MATHCAD is .127. Dim...

I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage. When a user double clicks a term in column B a multipage in a userform pops up. So if Semester 1 is double clicked the...

How do I add a continuous range say 5 to 16? Instead of adding 5 and 16 as below? I tried "To" and ":" for the "," but didn't work out. Sub oSum() Dim n&, s As Double, TbRay As Variant TbRay = Array(5, 16) For n = 0 To UBound(TbRay) s = s + Val (UserForm1.Controls("TextBox" &...

Here is my code !! In my code, there is no error but doesn't effect, I dont know why ? Appreciate for any idea. Sub InsertPicture(PictureFileName As String, TargetCell As Range, _ CenterH As Boolean, CenterV As Boolean) ' inserts a picture at the top left position of TargetCell ' the...

Example, -0.000153575754784432 In VBA the number is -1.115466458087536E-04 How to make it not show scientific number but just -0.000153575754784432

Hi, I have data in excel and one field in excel value is showing like (0.0816901332227654), and when I paste this data in a Access table the data is showing is like this (8.16901332227654E-02), the number should show in Access as showing in Excel. I don't know how can I fix it, pleas help me...

Hi all, I have an excel file where I loop over a matrix and want to calculate something for each cell within the matrix. I do this with the following <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit...

Here's an array I'm using: Dim Array (1 to 4, 1 to 400000, 1 to 12) as long How big is this array? How big would it be as a double or string array?

Good Afternoon, I keep getting a "error 13" Type mismatch for the piece of coding below and I'm not sure why. These are calculators just doing speed*time=distance and variations of that simple formula. Ideas? Sub ETA_CALC1()Dim name As String name = Sheets("Notes").Range("N4") Dim Path1 As...