Search results 132

  2. Search results
  3. excel
Card image cap
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

Nov20
Card image cap
AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

Nov1
Card image cap
Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

Sep1
Card image cap
SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Aug17
Card image cap
ListPivotsInfo

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

Aug13
Card image cap
Modal form open Workbook

Do not open workbook from userform after .show

Aug3
Card image cap
Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

Aug1
Card image cap
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Jul10
Card image cap
Excel user name

Get application user name or change it Originally from

Jun14
Card image cap
SubZero

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

May23
Card image cap
ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

Apr28
Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Apr23