Re: Stock Code Problem

Turn off the Transition Navigation Keys.

Tools - Options - Transition tab. 


Damon Longworth

2007 East Coast Excel / Access User Conference
April 2007
Atlantic City, New Jersey
http://exce
luserconference.com/ECEUC.html

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On
Behalf Of John Taylor
Sent: Monday, January 29, 2007 8:05 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Stock Code Problem

G'day all,

I'm having a problem with a stock market index code and
would appreciate
some help.

The code is ^AORD, and when it's viewed in edit mode it
shows ^^AORD because
the cell is formatted as centered, but it shows ^AORD when
viewing the cell
normally.

However, when the following piece of code runs the ^AORD is
"copied" from
cell K3, but pasted into cell B4 simply as AORD.  How can I
get it to
transfer correctly as ^AORD?

Range("A1") = i
    Range("B4") = Cells(i + 2, 11)

TIA

Regards,

John

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G