VBA-Excel 382
Visual basic for applications that works only in Microsoft Excel, aka macros
MatchIfUp_DateTime
Finds first cell in column that is a date/time from bottom to top (technically ...
SetAllPictures_MoveAndSize
Set shapes to "Move and size with cells" All shapes inside a sheet (or all ...
ANmaTable_FieldValue_Concat
Concatenates fields in certain row each with its header and returns the full ...
ANmExcelTableAddress
Returns reference of a table in Excel workbook. This is because not all tables ...
ItalicTextbox_Partial
Set part of textbox to italic, starting from StartingChar found in text until ...
ColorTextbox_Partial
Set part of textbox to certain color, starting from certain character found in ...
ANmaTableAddress
Returns the full name of table with its sheet name to be used in formulas or in ...
Range().top below hidden rows
Hidden rows change the .top of below ranges. It turns out that the range().top ...
.jpeg)
Hack VBE password in .xlsm
Remove VBE project password protection off of xlsm. This is screenshot on how ...
MergePDFsUsingPDFTK
Merges two PDF1 and PDF2 into PDFMerged, then delete PDF1 and PDF2 Using pdftk ...
