Search results 220

Sorted from new to old.
Card image
ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

Card image
WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

Card image
CapitalizeAllWords

Capitalize first letter in all words In a String

Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Card image
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

Card image
XLThumbView

Showing thumbnails inside sheet and enlarging each when click

Card image
LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Card image
Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

Card image
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

Card image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

Card image
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...