• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Only selecting values within quotation mark on Excel VBA Editor

PP3321

Active Member
For example, I have 3 lines of codes like this:

Code:
Print #1, "<column>" & Range("A1").Value & "</column>"
Print #1, "<column>" & Range("A2").Value & "</column>"
Print #1, "<column>" & Range("A3").Value & "</column>"

I want to select values within quotaiton mark. (A1,A2,A3)

Print #1, "<column>" & Range("A1").Value & "</column>"
Print #1, "<column>" & Range("A2").Value & "</column>"
Print #1, "<column>" & Range("A3").Value & "</column>"

Is it possible to do such thing?
 
Hi ,

What is the objective ?

If you press CTRL H , and enter :

("*")

in the Find What box , and check the box labelled Use Pattern Matching , you will be shown all of the listed text sections.

Narayan
 
@NARAYANK991
Thank you always for your answer.
I did not know User Pattern Matching...

I just saw someone doing multiple cursors to select words between tags all at
once.

capture.PNG
Source:

I wondered if we can do such thing using Excel VBA editor.
Or if there is a free software that will allow me to do it.
 
Back
Top