Question: I am having trouble with a VBA code. I want to display and (eventually delete) the two smallest numbers, but I am having trouble pulling

I am having trouble with a VBA code. I want to display and (eventually delete) the two smallest numbers, but I am having trouble pulling an array from the excel spreadsheet. Can someone help me write this code? Here is what I currently have.

Visual Basic Editor Sub help) Dim arr As Variant arr Range("A1:A7") Min 40 For i-LBound(arr) To UBound(arr) If i

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

(PLEASE ASSIST ME WITH THIS. IT CAN BE IN THE SIMPLEST FORM OF C++. I AM HAVING TROUBLE ORGANIZING THIS. THANKS) Lab Steps Step 1 An array is a group of variables. You reference the individual...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

MATHEMATICIANS RISE TO A CHALLENGE ne of the theorems we teach in eighth grade is a + b= *, where c is the length of the hypotenuse of a right triangle in Euclidean space, and a and b are the lengths...

> PLEASE SHOW STEP BY STEP INSTRUCTIONS Exp19_Excel_AppCapstone_Intro_Collection Project Description: You are the financial manager for Judis Art Gallery. One of your clients, Raymond Chancellor, has...

We need a Country class to keep track of the countries and a few details about them. We will also need a class called CountryCatalogue to keep track of the collection of Countries. Both these classes...

Hi, I was having trouble with this program which is part of an assignment question done in C++. If you could help me that would be really great. Thank you so much!!!! Part 2 Country Catalogue This...

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

For this assignment, you are to write a program to multiply two sparse matrices. You will implement a data structure that facilitates efficient processing of sparse matrices so that your program will...

Help me code the whole program in java Date.java public class Date { public int year; public int month; public int day; public int sYear; public int sMonth; public int sDay; //getter and setter...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Describe how auditing differs from accounting.

A nine - year bond has a yield of 1 0 % and a Macaulay's duration of 7 . 1 9 4 years. If the bond's yield increases by 5 0 basis points, what is the percentage change in the bond's price?

I need help with the following question

=+2 What cultural problems do you foresee in the relationships between the

=+2 Are there or can there ever be universal approaches to performance appraisal?

=+Germans and the Indonesians? In negotiations? In day-to-day operations?