Search results 85

Sorted from new to old.

ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Nov13

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sep23

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

Jul27

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Jul18

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Jun9

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7

USB Format in Car stereo

What format used to let Car stereo read USB thumb drive? To listen to MP3 ...

2023Sep29

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

End ( xlDown )

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

2023Aug28

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

1 2 ...5 6