copying single cell into merged cells

[KatyJohn]

I'm trying to copy a date from a single cell to 2 merged cell. The cells are merged because of the nature of the form. I can't run the date across the cell and I get an XX because the cell is not wide enough. I can't copy and special paste into merged cells with a macro.

katyjohn

 

[Rodney Jorgensen]

I don't see why you can't copy the date directly over, but could you just use a simple formula? Take the merged cell and inout =(cell addres of date). Example: if A1 & B1 are merged and the date is in C1, you could use this formula in the merged cells: =C1. That will transfer the date over.

Hope this helps.

 

[VoG]

Better to avoid merged cells and use Center Across Selection instead. See http://www.mrexcel.com/forum/showthread.php?t=335123

 

[Diablo II]

you can past if you click the cell then go to the foumula bar and past it in.

 

[ZVI]

Use Paste Special with Transpose