Skip to content

Instantly share code, notes, and snippets.

@DuongAQ

DuongAQ/Replace_Test01.bas

Created January 25, 2018 02:57
Show Gist options
  • Save DuongAQ/193eb22b80742b041ad2a9b05e8b8ec1 to your computer and use it in GitHub Desktop.
Save DuongAQ/193eb22b80742b041ad2a9b05e8b8ec1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Replace_Test01.bas
Option Explicit
Sub Replace_Test01() 'Excel VBA to replace strings.
Dim strA As String
Dim strB As String
strA=" (*"
strB=""
Rows("1:10").Replace strA, strB
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment