Search results 515

Sorted from new to old.
Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image
Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

Card image
Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

Card image
Modal form open Workbook

Do not open workbook from userform after .show

Card image
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

Card image
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image
Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Card image
DB connection driver

What is the Driver part in ConnectionString

Card image
Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

Card image
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

Card image
ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...