I need to paste data into Excel from OMNIStation to do roll-ups on
specific fields. But OMNIStation designates negative numbers with a
minus sign at the end of the number (e.g., "$10,236.60-"). So, I tried
recording a macro to remove the minus sign at the end and put it at the
beginning, at which point Excel then recognizes the number as a negative
value. Problem is, Excel doesn't record the keystrokes, rather it is
recording the contents of the cell...
Code:
--------------------
' Keyboard Shortcut: Ctrl+a
'
ActiveCell.FormulaR1C1 = " $10,236.60"
Range("D13").Select
End Sub
--------------------
That means when I run the macro on the next negative value cell it just
copies the same value into that cell. Not much help. Is there a way to
get Excel to record the actual keystrokes and not treat this as a
formula?


--
dbe4876
------------------------------------------------------------------------
dbe4876's Profile: http://www.excelforum.com/member.php...o&userid=27415
View this thread: http://www.excelforum.com/showthread...hreadid=469293