udf problem

Hello, I'm having trouble making a modification to my existing working code. I've tried multiple combinations but can't seem to get it to work. I would like to add the condition that if Worksheets("Index").Range("C28").Text = "1" Then this function will only evaluate Worksheets("Underlying...

Hello all, I've the below user defined function which works well, however i would like to extract only part of the output using vba, in the below case it is the second output glon2. I know how to do this in a spreadsheet as a CSE function however i don't intend on putting the results into a...

I have a Subroutine that works just fine, but I have had a request to make it a UDF I thought it would be easy there are just two variables one is a range and the other a single cell, but the range doesn't appear to translate as expected - debugging produces an "Application-defined or...

I'm trying to create a UDF / custom function that takes the place of four vlookups to return a boolean response. It seems to work fine when I'm debugging it (I have a separate sub which calls the function so I can step through it), but when I attempt to use it, it does appear in the autocomplete...

Hi, UDF functions can be called from a Worksheet, given they are 'Public functions' and are defined inside a Module (not in the Worksheet Code). But if a UDF function has variables that are defined as user defined type variables it will simply give a #VALUE! error: For example, if in a cell...

Hi, I have the following funtion from the guru files page Function VLOOKNEW(lookup_value, table_array As Range, _ col_index_num As Integer, CloseMatch As Boolean) ' Allows for col_index_num to be negative ' that matches the lookup value. Dim nRow As Long Dim nVal As Integer Dim...

Hi, I have a simple UDF function of myself that it is used in a worksheet as a normal function. Is the only UDF function used in the workbook as it is supposed to be used, and when called, it does what it should. The point is that, when I debug other macros, it generally passes through the...