VBA-Excel 380
Visual basic for applications that works only in Microsoft Excel, aka macros
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 ...
BoldTextbox_Partial
Set part of textbox to bold, starting from StartingChar (like : ) that found in ...
Pagebreak and Pagebreak preview
When setting the location of pagebreak, you need to have that sheet view set to ...