-
Need code posting help.
Hello,
When I post code several font statements show up though out the code similar to this: ?[font=Times New Roman]?
See sample below.
Any suggestion on correcting this?
Thanks
Ron
[VBA]
Sub FindShall()
Dim appExcel As Object
Dim objSheet As Object
Dim aRange As Range
Dim bRange As Range
Dim intRowCount As Integer
Dim strFileNameAndPath As String
Dim lngDisplayVal As Long
[/VBA]
-
Hi,
Are you trying to use the VBHTML Maker? If so, don't. Use the VBA tags, but just with raw code. It will take care of everything.
-
How to use the VBA tags is described at the link in my signature, Ron.
-
I used the VBA tags as discribed in the link and copied/pasted my code straight from the VBA editor. Any other suggestions?
Ron
-
Are you doing a paste special of sorts? Upload a (zipped) sample file containing some code.
-
No, I did not use paste special. Is it the file the code is in that you want me to upload? That would be a word file that contains the macro that I am working on.
My first post included a sample of the code copied directly from the document.
Ron
-
Right. If the code is in the document, instead of in the VB Editor, it'll paste weird. If you copy the code from a Word doc into a plain old text editor, or into the VB Editor, and THEN into here...it'll work.
Or, paste it here, then select it and hit the AA with the X through it (top-left of editing icons), then put the VBA tags...you should be okay.
-
I will try your suggestions. Thanks to all very much for the help.
Ron
-
Our pleasure, Ron. It's a VERY cool feature of this board. Mark007 custom-programmed it for us.
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