Hi PVH,
Yes, I've tried that, but it didn't change anything. Problem still continues. Returns error message:
"Run-time error '450': Wrong number of arguments, or invalid property assignment."
Thanks for engaging!
Correction: In my opening sentence I should have asked:
"Can you please advise how to use a WORD Selection Object to articulate a Word paragraph bullet from Excel. I'm told I'm presently trying to articulate via an EXCEL Selection Object from Excel, which is preventing my macro from running...
Strongm,
Other manipulation of the Word document from Excel is being successfully accomplished using lines as seen here:
[START]
With WordApp.Selection
.TypeText Text:=[insert text, or Excel variable, etc]
.Font.[formatting]
.TypeParagraph
.Style =...
REFERENCE thread222-1723548
Hi All-
Can you please advise how to use an Excel Selection Object to articulate a Word paragraph bullet from Excel. I'm told I'm trying to articulate via a Word Selection Object from Excel. Frankly, I don't know the difference. The particular piece of VBA that...
Thanks much for your help, but bummer, still not having success. Got the Object Library issue switched on via the References menu okay. But, still, the code copied from Word's macro recorder doesn't run in Excel. Specifically, the code that appears to crash is:
[START]...
StrongM, Thanks very much for your help. So apparently I have not "set a reference to the Word object library." Can you possibly point me to a source that would describe what that is and how to do it?
Thx!
Hi Folks,
Am using Excel VBA macro to create a MS Word document. Seeking efficient method to reset bullet lettering in Word list back to its first value, that is, reset to “a)” prior to printing a second, or additional list.
I'm using template and styles in Word to establish desired...
Hi Folks,
Am trying to avoid using VB to accomplish..
What would be the formula in cell #3?
Value in cell #1 is "85" , for example.
Cell #2 is located at Column 10, row 85.
I want formula in cell #3 to return value of cell #2.
Column number in formula in cell #3 would be fixed, I use...
Hi Folks,
Am trying to create a rudimentary "teams" web page that allows visitor to determine if a team exists in a nearby zip code region. ("Does your zip code exist on our list of team's zip codes?") Am trying to figure out how a data entry field in a web page can serve as criteria for a...
Later in the program when I do a comparison such as:
If Tag = 1234 Then...
it fails. However, if I go back to my original code and change it from
Tag = Cells(VariableRow, 1).Value
to
Tag = 1234
the above comparison results in TRUE. Also, in the initial case, when hovering over the name...
Hi Folks! I'm sure I'm overlooking an obviouse, but can't put my finger on why quote signs are appearing in the value stored at the below tag's address.
I want stored at Tag is: 12345
I'm getting stored at Tag is: "12345"
'***START***
Dim Tag
Dim VariableRow
VariableRow = 1
'Value entered...
Hi Folks,
Below subroutine seems to create the desired formula okay. However, when formula is written to target cell apostrophies seem to have been inserted, making the formula non-functional.
Desired formula is: =Sum(F1:F5)
Inserted formula is: =Sum('F1':'F5')
How do I build VB code such...
Much to my benefit, the wealth of informaiton continues....!
But... you lost me when you said the BOLD parts of the expressionare ALWAYS TRUE. I don't see any bold. I do see a red 6 and a red 8. Are they inferred bold? Are they therefore true becuase they're not declared? As I say, you lost me.
Does Excel's VBA support the use of Boolean logic, such as OR, or AND? For example, If ...Column = 1 OR 3 OR 8 Then...
Specifically, as used in If Then Else statement is most applicable.
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.