Search results 14

Sorted from new to old.

Returns the value of first duplicated item found in a range. This is to ...

Apr18

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

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

2022Mar11

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

A drop down menu for Text fields Another one, that needs some work to fulfill ...

2019Jun25

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

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

2018Jun30