Column Lengths

Giganews Newsgroups
Subject: Column Lengths
Posted by:  RWiederste…@gmail.com
Date: 19 Jan 2007

Got one range "Data" and one range "Calculations." Each separated by a
blank column.  I write a formula into the top column  of "Calculation."
I then have to ask,"I wonder how far down I have to paste this
formula?"  The answer is, of course, the same number of rows as are in
the "Data" range.  Is there an easy way to do this?  For example,
F1:Endrow=Forumula?  Should I be experimenting with the "offset"
property?

Replies