Posted to microsoft.public.excel.programming

GBH99

external usenet poster

Posts: 28

Wrong code?

Hello,

Please can someone point out my error below.

Range("I22").Select
ActiveCell.FormulaR1C1 = "=if(" & ActiveCell.Offset(0, -1) &
"-1500)<0,0,RoundDown((" & ActiveCell.Offset(0, -1) & "-1500)/900,0)+1)"

Cheers

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
Help with what is wrong with code	OssieMac	Excel Programming	1	March 28th 07 03:05 AM
Help with what is wrong with code	Joel	Excel Programming	0	March 28th 07 01:14 AM
Can someone tell me what is wrong with this code?	Ant	Excel Discussion (Misc queries)	8	November 14th 05 02:53 PM
What's wrong with this code, please?	Jim Berglund	Excel Programming	1	August 3rd 04 09:41 PM
What's wrong w/my code?	nrage21[_54_]	Excel Programming	5	July 28th 04 03:50 PM

All times are GMT +1. The time now is 08:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us