Search results 60

Sorted from new to old.

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

End ( xlDown )

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

2023Aug28

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Fix Excel Issue

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

2023Aug1

Enable Blocked Macros in O365 from OneDrive

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

2023Jul10

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

Popup button

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

2022Oct13

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

1 2 3 4