Posted to microsoft.public.excel.programming

Momo

external usenet poster

Posts: 45

Automatic Macro

Hi can anyone help,

I have created a dropdown list in excel using data validation which I am
then using via lookups to fill in a table below, but some of the column
headers are merged by two cells and others by four, is there any way to
create a macro by when a selection is made via the dropdown list it will
format the merged cells accordingly,

Thanks

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
Automatic run of Macro	Frank	Excel Discussion (Misc queries)	1	February 21st 07 03:10 PM
Automatic run of Macro	Tom Ogilvy	Excel Discussion (Misc queries)	0	February 21st 07 02:33 PM
excel - macro - automatic initiation of a macro at a pre-specified "system time"	arunjoshi[_3_]	Excel Programming	3	May 1st 04 09:42 AM
Automatic execution of macro	Paul-André Gollier	Excel Programming	1	January 30th 04 09:03 PM
Automatic Macro	ianripping[_3_]	Excel Programming	3	January 15th 04 05:22 PM

All times are GMT +1. The time now is 05:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us