-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula outputting incorrectly?
- Thread starter kpark91
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,084
- Office Version
- 365
- Platform
- Windows
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,341
- Office Version
- 365
- Platform
- Windows
I definitely don't have as good a success rate as that. Perhaps I don't hold my mouth correctly when posting.
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,341
- Office Version
- 365
- Platform
- Windows
My last post may have been misleading.
The majority of times I post a formula with < and no following space, the formula dispalys correctly anyway. However, if it doesn't then using code tags also doesn't seem to usually help. So the code tags success rate for me is poor if the standard method didn't work. If the standard method worked, my success rate with code tags is either 0% or 100% because I don't use code tags then.
In terms of why a formula would sometimes display correcly and sometimes not, schielrn made some interestion observations in post #17 of this thread.
The majority of times I post a formula with < and no following space, the formula dispalys correctly anyway. However, if it doesn't then using code tags also doesn't seem to usually help. So the code tags success rate for me is poor if the standard method didn't work. If the standard method worked, my success rate with code tags is either 0% or 100% because I don't use code tags then.
In terms of why a formula would sometimes display correcly and sometimes not, schielrn made some interestion observations in post #17 of this thread.
Hi there has been another occasion where the code was 'broken' when posted.
I'm guessing it has to do with the forum XML or whatever they're using.
Take a look:
http://www.mrexcel.com/forum/showthread.php?t=570660&page=4
I've tried posting
I'm guessing it has to do with the forum XML or whatever they're using.
Take a look:
http://www.mrexcel.com/forum/showthread.php?t=570660&page=4
I've tried posting
Code:
Option Base 0
Option Explicit
Sub GetCIK()
Dim X As Long, LastRow1 As Long, OutputRow1 As Long, CellContent As String, LastRow&
Dim pos1&, pos2&, OutputRow2&
Const StartRow As Long = 1
Const DataCol As String = "A"
Const OutputSheet As String = "URLs"
Const OutputCol1 As String = "B"
Const OutputCol2 As String = "C"
LastRow = Sheets("wquery").Cells(Rows.Count, DataCol).End(xlUp).Row
OutputRow1 = Worksheets(OutputSheet).Cells(Rows.Count, OutputCol1).End(xlUp).Row
OutputRow2 = Worksheets(OutputSheet).Cells(Rows.Count, OutputCol2).End(xlUp).Row
For X = StartRow To LastRow
If Sheets("wquery").Cells(X, DataCol).Value Like "*getcompany*CIK*" Then
OutputRow1 = OutputRow1 + 1
CellContent = Sheets("wquery").Cells(X, DataCol).Value
Worksheets(OutputSheet).Cells(OutputRow1, OutputCol1).Value = Left$(Split(CellContent, ";")(1), 14)
End If
If Sheets("wquery").Cells(X, DataCol).Value Like "*""nowrap*</td>" Then
OutputRow2 = OutputRow2 + 1
CellContent = Sheets("wquery").Cells(X, DataCol).Value
pos1 = InStr(1, CellContent, """nowrap""")
pos2 = InStr(1, CellContent, "</td>")
Worksheets(OutputSheet).Cells(OutputRow2, OutputCol2).Value = Mid(CellContent, pos1 + 9, pos2 - pos1 - 9)
End If
Next X
End SubIt seems like Peter was right xD but in my case, I could not use spaces.. except I could concatenate the strings with ;amp (&).
