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
|