VBA-Excel 279 Visual basic for applications that works only in Microsoft Excel, aka macros

Card image cap
Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

Card image cap
ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

Card image cap
Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

Card image cap
Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

Card image cap
Refreshing image

Refreshing image in ImageControl of VBE Userform When we change picture of ...

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Card image cap
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

Card image cap
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Card image cap
CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

Card image cap
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

Card image cap
IsThere_Remote

Checks if a file can be reached online or no Same as