sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm trying to add this formula to a cell using VBA but I'm getting an error, 1004 Application-defined or object-defined - I have no idea why if someone can explain please?
VBA Code:
Cell.Offset(0, 2).Formula = "=" & Cell.Offset(0, -1).Address & "/" & Cell.Offset(0, -2).Address & ""