Posted to microsoft.public.excel.worksheet.functions

deancarpenter deancarpenter is offline

external usenet poster

Posts: 3

How to run a macro with the IF command

I want a Macro to run only if a cell listed in column B says "Red" to create
a seperate spreadsheet.
I currently have 86 line items in this sheet which could potentially go
"Red", so the Macro needs to run each time this happens.

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
If command in macro	castleds	New Users to Excel	1	January 9th 07 11:20 PM
macro command	Param	Excel Worksheet Functions	2	February 23rd 06 07:51 AM
Macro Command	VickyC	Excel Discussion (Misc queries)	1	December 2nd 05 01:05 AM
macro command	Shifting of Multiple Row to the right	Excel Discussion (Misc queries)	3	September 15th 05 05:02 AM
macro ...if command, I suppose...	Mario	Excel Worksheet Functions	0	December 9th 04 11:29 AM

All times are GMT +1. The time now is 09:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us