Search results 61

Sorted from new to old.

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

ConcaUFO_RowsfromSheets

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

2020Nov11

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

Excel sheet textbox

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

2020Feb22

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

Bootstrap 4 cheat sheet

Bootstrap 4 cheat sheet, quick direct link as image

2019Apr9

SheetAdd_ANmar

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

2019Apr1

ShowThumb

ASP.Net ShowThumb.aspx file that generates image thumb from an image, official ...

2018Sep19

SheetName

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

2018Aug23

SheetDelete_ANmar

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

2018Aug9

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

2018Jul9

1 2 3 4