Search results 66

Sorted from new to old.

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Fix Excel Issue

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

2023Aug1

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

CreateUniqueList

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

2022Apr26

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17

WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3

Max + Min

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

2019Dec31

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

1 2 3 4 5