Search results 23

Card image cap
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

Card image cap
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

Card image cap
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

Card image cap
Add2Column

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

Card image cap
Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

UnProtect.zip

Card image cap
UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

Card image cap
Select workbook (or workbook/worksheet) (Frm5)

Gives your user ability to select a workbook from list of open workbooks within ...

Frm5.zip

Card image cap
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

Card image cap
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

Card image cap
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

Card image cap
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Card image cap
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...