Search results 60

Sorted from new to old.

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

O365 Blocked Macros

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

2023Jul10

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

1 2 3 4