|
-
March 22nd, 2001, 06:40 PM
#1
VBA String "=Wenn(F43-E43>0;F43-E43;"""")"
Hey VB experts,
I want to assign a formula to a cellobject:
Worksheets(4).Cells(43, 11) = "=Wenn(F43-E43>0;F43-E43;"""")"
VBA is not accepting the semicolon in the string. How can I force VBA to compile this expression.
Any answer will be appreciated
Jochen
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|