Search results 204

Sorted from new to old.

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

Arr_1Dim_2Str

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

2023Aug14

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

Range22DimArray

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

2023May11

ScanFolder

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

2023Apr7

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

1 2 ...5 ...12 13