View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] itsirkam@comcast.net is offline
external usenet poster
 
Posts: 1
Default Using the VBE: Selecting vertical instead of horizontal

Word can do it.

copy both parts to Word:

doga = 11
dogb = 12
dogc = 13

cata
catb
catc

Then in Word, click after doga (in front of the = sign), press and hold
Alt key while dragging down through =13. Only the = signs and values
will be selected. Copy selection (Ctrl+C).

Click after cata where you want the = to be and Paste (Ctrl+V) and you
will get :

cata = 11
catb = 12
catc = 13

Then copy/paste back to VBE