Search results 65

Sorted from new to old.

ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

2025Jun30

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

2025May26

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

SettingRead_Bulk

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

2024Nov3

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

3 Custom BS buttons

3 Custom-made button colors using Bootstrap. Because I suck at graphics, I ...

2024Jan21

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

1 2 3 4 5