Copy cells to variable number of rows

I need to copy a formula (that a macro has entered at W3 & X3) down to the
last row for that particuliar wk. I've figured out how to get the number of
rows for that wk( in this case i=93, i will change for each wk) but can't
figure out the syntax for the Range:

Selection.Copy
Range("W4: ? ").Select
ActiveSheet.Paste

instead of

Selection.Copy
Range("W4: ? ").Select
ActiveSheet.Paste

try

range("W4:W"&i).filldown


"Acct Supr - DCTC" wrote:

> I need to copy a formula (that a macro has entered at W3 & X3) down to the
> last row for that particuliar wk. I've figured out how to get the number of
> rows for that wk( in this case i=93, i will change for each wk) but can't
> figure out the syntax for the Range:
>
> Selection.Copy
> Range("W4: ? ").Select
> ActiveSheet.Paste

The .filldown didn't seem to work for me (likely something in the way I set
things up) but when I put Select in its place it worked just the way I
wanted. Thanks for the help. Do you know of a good book or class that help
me getting better at writing Macros?

"Duke Carey" wrote:

> instead of
>
> Selection.Copy
> Range("W4: ? ").Select
> ActiveSheet.Paste
>
> try
>
> range("W4:W"&i).filldown
>
>
> "Acct Supr - DCTC" wrote:
>
> > I need to copy a formula (that a macro has entered at W3 & X3) down to the
> > last row for that particuliar wk. I've figured out how to get the number of
> > rows for that wk( in this case i=93, i will change for each wk) but can't
> > figure out the syntax for the Range:
> >
> > Selection.Copy
> > Range("W4: ? ").Select
> > ActiveSheet.Paste

I haven't the experience with many Excel books in the last 5 years. Some
people here have recommended John Walkenbach's books. You can read reviews
at Amazon on Excel VBA books - there are lots of books to choose from.

"Acct Supr - DCTC" wrote:

> The .filldown didn't seem to work for me (likely something in the way I set
> things up) but when I put Select in its place it worked just the way I
> wanted. Thanks for the help. Do you know of a good book or class that help
> me getting better at writing Macros?
>
> "Duke Carey" wrote:
>
> > instead of
> >
> > Selection.Copy
> > Range("W4: ? ").Select
> > ActiveSheet.Paste
> >
> > try
> >
> > range("W4:W"&i).filldown
> >
> >
> > "Acct Supr - DCTC" wrote:
> >
> > > I need to copy a formula (that a macro has entered at W3 & X3) down to the
> > > last row for that particuliar wk. I've figured out how to get the number of
> > > rows for that wk( in this case i=93, i will change for each wk) but can't
> > > figure out the syntax for the Range:
> > >
> > > Selection.Copy
> > > Range("W4: ? ").Select
> > > ActiveSheet.Paste