Posted to microsoft.public.excel.programming

Bob Barnes Bob Barnes is offline

external usenet poster

Posts: 134

Error 1004 - Cannot change part of a merged cell.

I'm an Access Programmer running automation to Excel.

The Manager uses an Excel file that uses several "2 Merged Cells" to display
Values as Enlarged.

I should be able to redesign the Excel file, but it would be faster if I can
somehow
automatically transfer the data into the 2 merged cells?

Can this be done?

TIA - Bob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Runtime error '1004' Cannot change part of a merged cell	[email protected]	Excel Programming	0	July 11th 08 02:48 AM
"Cannot change part of a merged cell" when AutoFilter is turned on	[email protected]	Excel Programming	0	March 14th 07 05:31 PM
"Cannot Change Part of a Merged Cell" When updating link using mac	Madhava	Excel Programming	1	October 25th 05 10:14 AM
Cannot change part of a merged cell	happyPotter[_2_]	Excel Programming	2	July 6th 05 05:32 PM
ClearContent & 'Cannot change part of a merged cell' error	Richard[_34_]	Excel Programming	4	June 27th 05 08:06 PM

All times are GMT +1. The time now is 03:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us