Filldown Formula
in [Programming]
|
From: KWhamill on 16 Jul 2008 14:31 I'm looking for a foolproof technique to Filldown a formula when I don't know in advance how many rows i might have to fill. However, the column Immediately to the left will be populated when the formula is applied. Any suggestions would be great. Thanks, K
From: Mike H on 16 Jul 2008 14:37 Hi, Select the cell you want to fill-down and you will see a black square on the bottom right. Double click it and the column will down as far as the populated range in the column to the left. Mike "KWhamill" wrote: > I'm looking for a foolproof technique to Filldown a formula when I don't know > in advance how many rows i might have to fill. However, the column > Immediately to the left will be populated when the formula is applied. Any > suggestions would be great. > Thanks, > K
From: Rick Rothstein (MVP - VB) on 16 Jul 2008 14:42 If there are no empty cells between the first and last cells in the column to the left, then select the cell with your formula in it and double-click the small black square in the bottom right corner of the selection border. Rick "KWhamill" <KWhamill(a)discussions.microsoft.com> wrote in message news:08C78881-E13A-4E11-8AEE-C5083514D7E7(a)microsoft.com... > I'm looking for a foolproof technique to Filldown a formula when I don't > know > in advance how many rows i might have to fill. However, the column > Immediately to the left will be populated when the formula is applied. Any > suggestions would be great. > Thanks, > K
From: KWhamill on 16 Jul 2008 15:30 well thanks yes, I actually I knew that. but that's Ok cause I figured it out. I was looking for this: Range("D2:D" & Range("C65536").End(xlUp).Row).FormulaR1C1 = _ "=ABS(RC[10])/1000000" Not perfect but it works fine. I would like to make it specific to the data so if someone gets the bright idea to move the column (or maybe I should say 'when') the Macro will work even if i am not there to fix it. Thank you "Rick Rothstein (MVP - VB)" wrote: > If there are no empty cells between the first and last cells in the column > to the left, then select the cell with your formula in it and double-click > the small black square in the bottom right corner of the selection border. > > Rick > > > "KWhamill" <KWhamill(a)discussions.microsoft.com> wrote in message > news:08C78881-E13A-4E11-8AEE-C5083514D7E7(a)microsoft.com... > > I'm looking for a foolproof technique to Filldown a formula when I don't > > know > > in advance how many rows i might have to fill. However, the column > > Immediately to the left will be populated when the formula is applied. Any > > suggestions would be great. > > Thanks, > > K > >
|
Pages: 1 Prev: Chart Property (e.g.: .HasTitle) reset fails with run-time err Next: Sheet Tabs |