Search results 140

  2. Search results
  3. excel
Sorted from new to old.
Card image
Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4
Card image
XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1
Card image
Page area and Page Setup functions (Unfinished)

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

2018Jun30
Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30
Card image
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26
Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24
Card image
ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17
Card image
RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17
Card image
WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16
Card image
BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16
Card image
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15
Card image
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14
Card image
FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11
Card image
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10
Card image
Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10
Card image
FindName

Finds a name in a workbook, returns true or false

2018Jun10
12...89