View Full Version : 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
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
Zack Barresse
12-10-2004, 02:08 PM
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. :)
Anne Troy
12-10-2004, 02:27 PM
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
Zack Barresse
12-10-2004, 02:57 PM
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
Anne Troy
12-10-2004, 03:19 PM
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
Anne Troy
12-10-2004, 03:32 PM
Our pleasure, Ron. It's a VERY cool feature of this board. Mark007 custom-programmed it for us. :)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.