MrExcel.com - Your One Stop for Excel Tips & Solutions

Pasting to merged cells

Posted by Lewis on December 01, 2001 11:28 AM

Hi,

I have a macro that copies and pastes data from one sheet to another.

the code is

Sheets("Records").Select
ActiveCell.Offset(0, 1).Select
Selection.Copy
Sheets("Update Problem").Select
Range("C6").Select
Selection.PasteSpecial , Paste:=xlValues

However this does not paste to some cells which have been merged.

Any suggestions gtatefully received

Lewis

Posted by CMorrigu on December 03, 2001 12:52 PM

try assigning activecell.value to a variable, switching sheets, and then assigning activecell.value to the variable
ShadowSource