OK, I celebrated too soon :-(
It works great with multi-row cells, but with cells merged from a single row
and multiple columns, it copies text from the row above the row I run the
macro in.
Also, can I assign a key in the code itself?
Finally, without going through conniptions with assigning security can I set
it so that it runs the macro in any sheet I bring up?
Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com
k.e.e.n., inc.
Milwaukee, WI, USA
+1-414/431-8775
Pune, MH, India
+91-20/30223100
"Stefi" wrote in message
...
Select the merged cell, then run this macro:
Sub UnMergeCopy()
Selection.MergeCells = False
On Error Resume Next
Selection.FillRight
Selection.FillDown
End Sub
Regards,
Stefi
"Anil Gupte" ezt írta:
I am looking for a simple macro that will umerge a cell and copy the
value
in the original merged cell into all the cells created as a result of the
merge. Any suggestions?
Thanx,
--
Anil Gupte