TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
What's the correct syntax if I want to add a ] to the end of a cell if it doesn't exist?
I have tried
But this fails with "Runtime error 424: object required".
Many thanks for your thoughts.
What's the correct syntax if I want to add a ] to the end of a cell if it doesn't exist?
I have tried
VBA Code:
For a = 2 To lastrow
If Right(Range("E" & a), 1).Value <> "]" Then Range("E" & a).Value = Range("E" & a).Value & "]"
Next a
But this fails with "Runtime error 424: object required".
Many thanks for your thoughts.