Search results 164

Sorted from new to old.

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Zoomed iframe

Show iframe zoomed or in scale Thanks to

2023Aug4

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

1 2 ...10 11