Search results 41

Sorted from new to old.

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

2024Feb10

Excel clipboard bug

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

2023Dec27

ChartLabelsNumberFormat

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

2023Dec23

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Column1Range

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

2023Oct7

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

ANmaRemoveDuplicates

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

2022Sep25

GetHeaders

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

2022May5

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Window and screen sizes in jQuery

Get the size of the screen, current web page and browser window using jQuery ...

2021Mar18

1 2 3