Posted to microsoft.public.excel.worksheet.functions

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

Retaining conditonal formats

Good point.

Thanks

On Mon, 8 Feb 2010 21:52:01 -0800, OssieMac
wrote:

I like the idea Gord but using Target.Value prevents a formula being entered
on the worksheet. Using Target.Formula seems to work better.

myValue = Target.Formula
.Undo
Target.Formula = myValue

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
retaining formats when referring to cells	Michaeld	Excel Discussion (Misc queries)	4	August 25th 07 12:28 PM
5 or more Conditonal formats	Hawksby	Excel Discussion (Misc queries)	3	March 9th 07 03:16 PM
Multiple Conditonal Formats	Dave	Excel Discussion (Misc queries)	4	November 2nd 06 11:47 PM
Retaining formats	grok	Excel Discussion (Misc queries)	11	October 31st 06 07:29 PM
Nested Ifs In Conditonal Formats	ANDYPAND	New Users to Excel	1	August 2nd 05 04:25 PM

All times are GMT +1. The time now is 06:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us