- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Column Lengths

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?

- Re: Column Lengths posted by Earl Kiosterud on Fri, 19 Jan 2007
- Re: Column Lengths posted by Roger Govier on Sat, 20 Jan 2007