Search results 60

Sorted from new to old.

DrawAllAutoShapes

Create new sheet and draw all autoshapes inside. From AI Copilot

Sun 9AM

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

Nov11

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

Oct11

Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

Oct10

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Sep30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Sep30

ConditionalFormatting_Clear

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

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

2024Sep5

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

ChartLabelsNumberFormat

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

2023Dec23

1 2 3 4