Skip to content

Latest commit

 

History

History
11 lines (9 loc) · 484 Bytes

README.md

File metadata and controls

11 lines (9 loc) · 484 Bytes
Raw

excel-regex-insert-content-before-after-VBA

  1. Press ALT + F11 in Excel to open the VBA console
  2. Copy and add this module
  3. The function will be available in the Workbook

Function RegxFunc takes as arguments:

  • strInput As String => The content to be matched
  • regexPattern As String => The pattern to be matched against
  • insertBefore As String => The content to be inserted before the matched text
  • insertAfter As String => The content to be inserted after the matched text