[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

R1C1 Formula - ISERROR Issue

Hello Experts,

Have the following lines in some code and it seems to be getting caught. What have I done wrong exactly?

Regards

LK
ws.Cells(x, 2).FormulaR1C1 = "=IF(ISERROR(INT(RC[-1]),"""",INT(RC[-1]))"
ws.Cells(x, 3).FormulaR1C1 = "=IF(ISERROR(MOD(RC[-2],1),"""",MOD(RC[-2],1)"

Open in new window

0
lkirke
Asked:
lkirke
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
ws.Cells(x, 2).FormulaR1C1 = "=IF(ISERROR(INT(RC[-1])),"""",INT(RC[-1]))"
ws.Cells(x, 3).FormulaR1C1 = "=IF(ISERROR(MOD(RC[-2],1)),"""",MOD(RC[-2],1)"

Missing paren ;-)

Kevin
0
 
lkirkeAuthor Commented:
Its always the way. Thank you. :)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now