PDA

View Full Version : Merged Cells :(



ads_3131
03-08-2011, 01:56 AM
How come i cant my code to copy something from one cell to another which is a merged cells......?

It works fine copying & pasting in any normal cell

For example using un-merged cells such as just (A7) i set my code to copy from one cell (C10) and paste into another (A7) when a checkbox is clicked.....works fine.....

However doing the same thing... if cells A7-B7 are mereged it doesnt display anything :S

Has anyone got any recommendations.......?

Bob Phillips
03-08-2011, 02:00 AM
Range("C10").Copy Range("A7").MergeArea