VBA: Cell Range
Closed
shellboy
Blocked Profile - Aug 16, 2017 at 04:18 PM
- Posts
- 2
- Registration date
- Monday August 14, 2017
- Status
- Member
- Last seen
- August 15, 2017
Blocked Profile - Aug 16, 2017 at 04:18 PM
Aug 15, 2017 at 08:26 AM
Aug 16, 2017 at 04:18 PM
Write now, you are trying to compare a string(RFactor as String) to an integer (.05)!
Do not declare the RFactor as anything.
Try this, in a cell place the value:
=Royalty(.06)
And see what the cell turns into.
Also, you must place this Royalty subroutine, into a module, not a worksheet.