Excel 2000. shared spreadsheet, merged cells cannot copy

  • Thread starter Thread starter Greg Simms
  • Start date Start date
G

Greg Simms

Hello, I have a shared spreadsheet which has merged columns. when I copy
this data and paste it in to another area, the pasted area becomes umerged
with the new data. Is their a way around this using VBA code. or otherwise

Many thanks


Greg Simms
 
Hi Greg


I would advise strogly against Merged cells, they always cause grief. Go
to Format>Cells>Alignment and use "Center across selection" instead

*****Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum & Business Software*****
 
Back
Top