Search results 33

Sorted from new to old.

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Sep21

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Mar12

Excel clipboard bug

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

2023Dec27

ChartLegendCenter

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

2023Dec21

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

SubZero

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

2023May23

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

1 2 3