MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Change event

  Asked By: Koila    Date: Oct 31    Category: MS Office    Views: 695

I have a spreadsheet that is linked to a
stock market data provider to give real-time
data on a 1-minute basis. The data I receive
is constantly overwritten in the same cells.

I would like to "grab" this data and store
it in another set of columns. How do I do this?

For example:

Received data:
........ Col A ............... Col B . Col C
Row 1 .. 3/23/05 9:32:00 AM .. INDU .. 10400.34

Stored data:
........ Col E ............... Col F . Col G
Row 1 .. 3/23/05 9:30:00 AM .. INDU .. 10408.22
Row 2 .. 3/23/05 9:31:00 AM .. INDU .. 10405.16
Row 3 .. 3/23/05 9:32:00 AM .. INDU .. 10400.34

I found the following code snipped in Excel Help..

Sub Worksheet_Change(ByVal Target as Range)
.. Target.Font.ColorIndex = 5
End Sub

.. but I can't figure out how do declare or set
"Target". Any ideas?



1 Answer Found

Answer #1    Answered By: Mehr Malik     Answered On: Oct 31

I'm not sure I completely understand what you are trying to do,
but "target" is a Range object, within which are cells  to which
calues can be assigned, or extracted. Can you post the rest of the

Didn't find what you were looking for? Find more on Change event Or get search suggestion and latest updates.