H
Harlan Grove
INTENTIONALLY CROSSPOSTED!
Just found out that VBA code in the beta Google Groups archive can be fubar.
The article http://makeashorterlink.com/?R1EA128AA, which is a link to
http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd
includes the statement
Set xlapp = CreateObject("Excel.Application")
which includes an embedded HTML hyphen (decimal char code 173) between the o
and n. Copy this line and paste into an Excel cell to see it.
The article in original format (http://makeashorterlink.com/?E1FA328AA,
which is a link to
http://groups-beta.google.com/group...t.functions/msg/e249f6c074a3adfd?dmode=source
doesn't include this unwanted character.
So, if you're going to paste code (or maybe formulas as well) from the beta
Google Groups archive, you'd better do so from original format articles
rather than from HTML formatted versions.
Just found out that VBA code in the beta Google Groups archive can be fubar.
The article http://makeashorterlink.com/?R1EA128AA, which is a link to
http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd
includes the statement
Set xlapp = CreateObject("Excel.Application")
which includes an embedded HTML hyphen (decimal char code 173) between the o
and n. Copy this line and paste into an Excel cell to see it.
The article in original format (http://makeashorterlink.com/?E1FA328AA,
which is a link to
http://groups-beta.google.com/group...t.functions/msg/e249f6c074a3adfd?dmode=source
doesn't include this unwanted character.
So, if you're going to paste code (or maybe formulas as well) from the beta
Google Groups archive, you'd better do so from original format articles
rather than from HTML formatted versions.