Blogs about: Udfs
Featured Blog
Cell Has Data Validation
Public Function Cell_Has_Data_Validation(RngCell As Range) As StringOn Error GoTo Cell_Has_Data_Validation_ErrorHandler Dim LngCellValidationType As Long‘========================================… more →
User Defined Functions In VBA
Cubic Spline Update
— 1 comment
dougaj4 wrote 4 days ago: The previous post in this series presented a User Defined Function (UDF) to fit a cubic spline to a … more →
Reinforced Concrete Moment-Curvature – 2; Shrinkage and Creep
dougaj4 wrote 1 week ago: The previous post in this series provided an Excel User Defined Function (UDF) to find the short te … more →
Reinforced Concrete Moment-Curvature - 1
— 1 comment
dougaj4 wrote 4 weeks ago: The flexural curvature of any beam composed of material with linear elastic behaviour, subject to a … more →
Cell Has Data Validation
userdefinedfunctionsinvba wrote 1 month ago: Public Function Cell_Has_Data_Validation(RngCell As Range) As StringOn Error GoTo Cell_Has_Data_Vali … more →
Reinforced Concrete Section Analysis - with prestress
— 1 comment
dougaj4 wrote 1 month ago: The simplified reinforced concrete section analysis spreadsheet presented here has been revised to a … more →
Stringize A Range
userdefinedfunctionsinvba wrote 1 month ago: Public Function Stringize_A_Range(RngInQuestion As Range, Optional StrDelimiter As Variant, Optional … more →
Evaluate Polynomial
userdefinedfunctionsinvba wrote 2 months ago: Public Function Evaluate_Polynomial(RngExponents As Range, RngCoefficients As Range, RngX As Range) … more →
Excel SUM - Excel Auto SUM Function - Free Excel Tutorials
Ask This CFO wrote 2 months ago: The Excel SUM function is probably the most often used function in Excel spreadsheets. A short cut … more →
Excel Keyboard Shortcuts - Fn Keys in Excel
Ask This CFO wrote 2 months ago: F1 Displays the Help Window CTRL+F1 Closes and reopens Help Window. ALT+F1 Creates a chart based … more →
Three UDFs
— 1 comment
dougaj4 wrote 2 months ago: This post is in response to recent discussions at Daily-Dose-of-Excel where many and various workshe … more →
Match UDF
userdefinedfunctionsinvba wrote 2 months ago: Public Function Match_UDF(RngValue2Find As Range, Rng2Search As Range, Optional BolCaseSensitive As … more →
LatPile - Analysis of Lateral Loads on Piles
dougaj4 wrote 2 months ago: This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles … more →
Approximate Solutions of Polynomial Equations
dougaj4 wrote 3 months ago: Following on from the previous post, this post presents a number of methods of solving polynomial eq … more →
File Date And Time
userdefinedfunctionsinvba wrote 3 months ago: Public Function File_Date_And_Time(StrFileSpec As String) As String On Error GoTo File_Date_And_Time … more →
Evaluating Polynomial Functions
— 4 comments
dougaj4 wrote 3 months ago: A polynomial function is a function of the form: a + b*x + c*x^2 + d*x^3 … and the derivative … more →
Count Shapes In ActiveWorksheet
userdefinedfunctionsinvba wrote 3 months ago: ‘============================================================================================= … more →
Remove Bottom Row From Supplied Range
userdefinedfunctionsinvba wrote 3 months ago: ‘============================================================================================= … more →
Remove Top Row From Supplied Range
userdefinedfunctionsinvba wrote 3 months ago: ‘============================================================================================= … more →
Remove Left Column From Supplied Range
userdefinedfunctionsinvba wrote 3 months ago: ‘============================================================================================= … more →
