Excel Watch Value truncated

[osx99]

I'm trying to view some web extract data in a Watch window in excel but it seems to be truncated in the view (not in the variable)

I've tried copying and pasting the value into a text file but it's still truncated

Are there settings in excel/vba editor for this or an alternative?

BAsically I'm trying to view the contents of horseHtmls from

regex.Pattern = "horse_id=[0-9][0-9][0-9][0-9][0-9][0-9]&"
            Set horseIDMatches = regex.Execute(horseHtmls(j))
            horseID = Replace(Replace(horseIDMatches(0), "horse_id=", vbNullString), "&", vbNullString)
            curHorseSpans = Split(horseHtmls(j), "span")

 

[HarleyQuinn]

You could try printing it to the Immediate window with:

Debug.Print horseHtmls(j)

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.