Search results 11

Sorted from new to old.
Card image
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Card image
Range2Block

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

Card image
GetHeaders

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

Card image
DynamicFill

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

Card image
Fill down

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

Card image
GetColumnIndex

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

Card image
ShapeRange_BG

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

Card image
InSheet_ChangeImage

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

Card image
Copy formulas

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

Card image
UnMergeFill

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

Card image
FormulasFlatten

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