All Questions
Tagged with custom-function vba
7 questions
1
vote
2
answers
164
views
Excel Custom Function returning a Range
Please forgive if the question has been asked before but I'm new to Excel VBA and stackoverflow.
I'm trying to write a custom function to merge two cells together maintaining the original formatting ...
- 13
0
votes
0
answers
62
views
Getting error 91 in this range-defining macro? [duplicate]
I am having trouble with defining a range using custom functions. Here is the main macro:
'1 Selección del archivo de nóminas
Dim nominas_wb As Workbook
Dim nominas_path As Variant
...
user19206253
0
votes
2
answers
366
views
Function in Excel VBA to calculate the average point in a circular set of numbers
I am trying to create a function that gives the average of a set of numbers.
The numbers are the tooth positions of a cog with 37 teeth. The primary tooth is tooth 1 (identifiable as painted). Damage ...
- 45
1
vote
2
answers
2k
views
Excel VBA custom functions help dialog
I've been making lots of functions over the years for Excel VBA, but I've always wondered how to make a more detailed help dialog box.
For built in functions, you get something like this:
How can I ...
- 1,728
0
votes
1
answer
476
views
VBA: getHTML as custom function - Avoid several HTML retrivals
I am using this to retrieve HTML from a webpage
Function GetHTML(url As String) As String
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", url, False
.Send
GetHTML = ....
- 567
2
votes
1
answer
645
views
Excel custom formula with IF statements and INDEX, MATCH returns a #VALUE error
I am extracting values from one Excel sheet to another. I use the following formula:
= IF(ISBLANK(IFNA(INDEX(Range1;Row;MATCH(Dates;Range2;0));Error1));Error2;IFNA(INDEX(Range1;Row;MATCH(Dates;...
- 177
0
votes
2
answers
112
views
Transform Sub to UDF getting (#VALUE!)
I have a program Sub which works well. I want to convert it into a custom Function, but when I use this function in Excel an error (#VALUE!) occurs
Function ТридцатьТРи(Diapozon As Integer)
'для ...
- 195