May be something like this?

Sub enterData()
Dim r As Range
Set r = [A1].CurrentRegion
Do
r.Cells(1) = InputBox("Please enter next value:", "Data entry")
r.Copy [A2]
Set r = [A1].CurrentRegion
Loop Until [A1] = -1
End Sub

"0o0o0" ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: ...
you know exactly what im talking about ( although the writeup you posted
didnt work for me)

Really .. i want to see institutions who bought in through out the
day...
but to simplify it on here I just said i needed a stock ticker in
excel..

that once posts say $3.45

a minute later it will say if the stick went up.. $3.46

and just below that would be the old stock price ( $3.45 )

and it just keeps going.. so by the end of the trading day the original
$3.45 would/could be down at cell 1000 say.. and all the stock prices
in minute intervals would be posted on one big list.

possible?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/