Posted to microsoft.public.excel.programming

Kevin Porter Kevin Porter is offline

external usenet poster

Posts: 38

Code for dealing with #REF

I have some fields that end up #REF because of deletes that are done. I
would like to look at that field, if it contains #REF then I want that field
to be the sum of all the columns in that row. If it doesn't then I want it
to equal what it equals.

Thanks,

Kevin Porter

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
Dealing with #VALUE!	Maracay	Excel Discussion (Misc queries)	3	February 10th 09 03:35 PM
dealing with time	Rhydderch	Excel Worksheet Functions	5	January 12th 09 11:37 PM
Dealing with +/- Values, Need Help	Dust Devil	Excel Worksheet Functions	1	April 18th 08 11:02 PM
card dealing	RobcPettit[_2_]	Excel Programming	4	November 28th 06 08:52 AM
Dealing with pop-ups	Jasons	Excel Programming	1	November 7th 04 07:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us