Posted to microsoft.public.excel.programming
|
|
How to merge excel using vba
And you have another reply to your other post, too.
It's a macro solution that would take longer than what you did with the
worksheet formulas <vbg.
Lillian wrote:
Thanks I got it.
-----Original Message-----
Select Columns C to G (so that the hidden D-F columns
are within the
selected area).
Then go to Format menu - Column - Unhide.
Darren
"Lillian" wrote in
message
...
Darren:
Now I hide my D,E,F columns, I do not know how to
unhide, those columns is gone, how did I put back.
Lillian
-----Original Message-----
You can get around the deletion problem as follows:
Select Column G, and click Copy.
(Don't change the selection)
Then Edit menu - Paste Special - Values
Darren
"Lillian" wrote in
message
...
I did try your formula, the all the data is in columnG,
but if I try to delete D,E.F column, then G column
become no readable, because is point to
=D1&" "&E1&" "&F1
, so I have to hide the D,E.F column, it's ok, but look
funny on the database, the best way is using VBA code,
do
you know how to do that, I really appreciated it.
Lillian
-----Original Message-----
Lillian,
In column G (or anywhere), enter
=D1&" "&E1&" "&F1
That is a worksheet formula.
If you need a VBA macro, you have to provide more
details.
HTH
Anders Silvén
"Lillian" skrev i meddelandet
...
I have big excel spreed sheet, on the columnD is
street
#,on the columnE is direction, on the columnF is
street
name, example:
D E F
123 S Main street
223 N Hill street
how can I merge DEF together become 123 S main street
by
using VBA macro.
thanks.
Lillian
.
.
.
--
Dave Peterson
|