Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

Simple code error statement

In this line:
C.Offset(0, 4).Value = Round(qty * rate * Data / 100, 2)
the Round statement is giving this error:
Wrong number of arguments or invalid property assignment

Why is this, please?
C is dimmed as Range, the other variables As Long.

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.601 / Virus Database: 382 - Release Date: 29/02/2004

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 simple if statement	Lou H[_2_]	Excel Worksheet Functions	3	November 7th 08 05:40 PM
Simple IF statement	Connie Martin	Excel Worksheet Functions	0	November 30th 06 06:09 PM
Simple IF statement	Alok	Excel Worksheet Functions	0	November 30th 06 05:51 PM
Simple IF statement	Dave F	Excel Worksheet Functions	0	November 30th 06 05:49 PM
Simple IF statement	Connie Martin	Excel Worksheet Functions	0	November 30th 06 05:42 PM

All times are GMT +1. The time now is 11:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us