Search results 85

Sorted from new to old.

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

SubZero

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

2023May23

Range22DimArray

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

2023May11

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

Windows 10 video files and OneDrive

Fixing generating videos thumbnail in Windows 10 Download app from

2020Oct31

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17

1 2 3 ...5 6