Christopher Kibble's Technical Ramblings
  • Generating a List of Values in Excel (VBA)

    2009-05-09 Excel VBA

    I frequently find myself needing to create lists of values I have in Excel in one cell. For example, I might get have a column of IDs and I need to create a comma delimited list of them to put into a SQL Query. I have the following function I put in an XLA that loads with Excel to generate these lists. 1Public Function …

    Read More

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Finding or Recovering your WSL Data
  • Lenovo Vantage IMController Vulnerability - ConfigMgr Query
  • Lenovo Thunderbolt Firmware Version Detection
  • Import Teams Meeting Into Camtasia

Categories

CONFIGURATION-MANAGER 20 SYSTEMS-ADMINISTRATION 13 TROUBLESHOOTING 11 PKI 10 POWERSHELL 9 CONFERENCES 5 APPLICATION-PACKAGING 4 MSOFFICE 3 ACTIVE-DIRECTORY 2 DOMAINS-AND-HOSTING 2
All Categories
ACTIVE-DIRECTORY2 APPLICATION-PACKAGING4 CONFERENCES5 CONFIGURATION-MANAGER20 DOMAINS-AND-HOSTING2 EXCEL1 GEEKING-OUT1 GOOGLE1 GOOGLE-CHROME1 IPHONE1 JAVA1 MCAFEE-ENDPOINT-ENCRYPTION2 MICROSOFT-DOCS1 MSDOCS1 MSOFFICE3 NINITE1 PKI10 POWERPOINT1 POWERSHELL9 SYSTEMS-ADMINISTRATION13 TROUBLESHOOTING11 WINDOWS-101 YNAB2
[A~Z][0~9]

Series

STANDING-UP-A-CERTIFICATE-AUTHORITY 9 VIDEOS 5 STANDING-UP-A-GOOGLE-CERTIFICATE-AUTHORITY 2 SPEAKING-ENGAGEMENTS 1

Tags

CONFIGMGR 20 POWERSHELL 17 MSOFFICE 12 CA 9 PKI 9 SQL 9 EXCEL 7 MMS 7 GOOGLE 4 AUTOIT 3
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA9 CAMTASIA1 CHROME3 CITRIX1 CONFIGMGR20 DOMAINS2 EDGE1 EXCEL7 FIRMWARE2 FLASH1 GITHUB2 GOOGLE4 IPHONE2 JAVA1 LENOVO2 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE12 NAS1 NESSUS1 NINITE1 NOTEPAD++1 PKI9 POWERPOINT1 POWERSHELL17 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS-103 WIZTREE1 WSL1 YNAB2
[A~Z][0~9]