Macro to copy active cell

Giganews Newsgroups
Subject: Macro to copy active cell
Posted by:  Kou Vang (kou.va…@dot.state.mn.us)
Date: Mon, 6 Oct 2003

I'm trying to write a macro to copy a row of data that has
only one data point across a number of columns that has
the year.  So what I want to be able to do is to copy the
data, and somehow reference the year, which is in the
first row 1.  So it would give me the data and the year of
the one and only data point.  I was thinking it must
involve a For Each Cell statement.  Thanks.  Sorry if it
sounds a bit vague.  It's either a macro, or go through
2300 records by hand, and I don't think I want to even
think about the second one.

Replies