![]() |
|
#2
|
|||
|
|||
|
In VBA each variable declared on the same line needs to be given a datatype. In your declarations only the last variable on the line is typed. This results in all the other variables being assigned the default datstype of Variant.
So Code:
Dim scriptName, str_prompt, str_lower1,… Code:
Dim scriptName as String, str_prompt as String, str_lower1 as String,… |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy a selected range of a document to a new document with preserving formatting,header and footer | RobertDany | Word VBA | 10 | 08-10-2021 04:04 AM |
| Insert Comments from List for Whole Document and for Only Selected Portion of Document | rekent | Word VBA | 8 | 11-10-2020 11:01 PM |
Copy selected text from one document and paste to new document in same position on the page
|
gasparik | Word VBA | 1 | 05-11-2020 05:41 AM |
When multiple documents open, undo/redo in one document affects others?
|
seanspotatobusiness | Word | 3 | 07-28-2018 03:15 PM |
Can I undo a repaired document?
|
uberscribbler | Word | 2 | 11-18-2014 11:27 AM |