custom function

Hello, I was able to find the below code for a custom function to read a cell and pull back the delimited value to a cell. Function ExtractElement(str, n, sepChar) ' Returns the nth element from a string, ' using a specified separator character Dim x As Variant x = Split(str...

Parameters which can't change I use 14 different data sets, which are stored in regression formulas (y=mx+b) in 14 different workbooks. This is equivalent to a couple of 10x10 values tables in each file. These data sets are referenced in ton of workbooks in a various tedious way. I want to...

Hello, Your help would be really appreciated! I have an excel file which reports corporate data and includes a macro. The macro copies and pastes a range into the body of an email. I've been using this code for over 3 years and this is the second time this happens in two separate files. I...

I have four custom formulas that I use a lot. Countcellcolor, Countfontcolor, Sumcellcolor and Sumfontcolor. Co-workers would also like to use it, but they always ask me what the input format is. I would like to add details to the functions so that they can use it independently.</SPAN> Is there...

I am trying to create a custom function that will be used on multiple different sheets. Depending on the data on each sheet, the custom function needs to calculate a few different ways. One of the inputs needed for the function to know what to do is "NumNewDiags". I currently have another...

Hello everyone! Suppose I have the following range: <tbody> Project Name Color Project A yellow Project A green Project A red Project A green Project A green Project B blue Project B yellow Project B yellow Project B blue </tbody> I would like to code a custom function...

I have the following functions: 1. =MID(H2, FIND(":", H2) + 1, FIND(",", H2) - FIND(":", H2) - 1) and 2. =MID(H2, FIND(":", H2, FIND(":", H2) + 1) + 1, (LEN(H2) - 1) - FIND(":", H2, FIND(":", H2) + 1)) The only variable is H2. NOTHING else should change. How can I create a VBA function to...

Hello VBA and UDF world, I have a UDF/Custom Function that works the 1st Time it's ran, but when I try to use the data in a pivot table the function attempts to recalculate and returns #VALUE. I have researched this issue, came to some conclusions, but can't figure it out entirely... I found...

I'm trying to write a function to test if a cell contains a website. So far I've got: Function IsURL(text) Dim test As Variant Dim eml As Variant eml = InStr(text, "@") 'if not present, position = 0 test = InStr(text, ".com") If eml > 1 Then IsURL = "email" ElseIf test > 4 Then IsURL =...

I am trying to generate 15000 random numbers that have similar charities to the same number of historical data points. The data is approximately from the t distribution, with the only exception being that it has skewness of -.21. Does anybody have any vba code that will accomplish these...

My goal is to insert a dynamic amount of rows to a table. The number of rows I need to insert will be the difference of rows from columnA on sheet1 to the number of rows in columnA on sheet2. I am assuming creating a function within my macro will be the best way to go about this. I appreciate...

Hi there, This question is more out of curiosity than necessity. Does anyone know of a Function that has been made that adds an argument to the vlookup Function that allows for the index column to be choosen as the result column is choosen. i.e. =vlookup(A1,2,C:F,4,0) the 2 is the index...

Hello, I am new to this forum and I am new to Excel VBA. I apologize if this is redundant with another thread or post, but I have looked high and low via google and on this forum and have yet to found what I am looking for. I started with a simple if, then, else function as follows...

Hi there, I built a custom function in vba. When called from a cell in excel, I want the parameters to pop up to assist the user as they would for a built-in excel function. Is there a way to do this? Example of kind of function I'm talking about: function test (hello as Integer) As...

Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a problem with a custom function which does not calculate correctly. This does not seem to be an issue with manual/automatic calculation settings, nor (I think) related to whether the...

I'm trying to figure out if there is any way of performing a logical check (possibly by way of a custom function?) to ascertain whether a cell contains a text string (no numbers) and is all in upper case (or lower case, or Proper Case). The reason for this is that I receive approx 10,000 rows...

Can anyone help me with the following code, I am trying to write a Function that will execute a query and show the results. This is as far as I have been able to get with my limited knowledge, any help will be greatly appreciated... In case you are wondering, I have verified that the connection...

I am writing some custom functions to be saved in an Add-In file, but am having trouble saving named ranges. I would like named ranges in the Add-In file to be available in other spreadsheets. Is there a way to do this? Or is there a way to take a range from Excel and save it into a globally...

hi all In an effort to save time, i've wasted a lot of time using the IF function to create this...

I'm having a hard time getting a custom vlookup formula to work. I need to be able to change a part of the range in the vlookup dynamically based on a cell value. This is what I came up with but it gives me a value error. Can anyone help? Function VL(val As Variant, RNG As Range, col As...