Copy down

[JSoto]

Hi,

I need help with this code. I'm just learning about this, so maybe this is to basic, but I still need help!

Here we go:

In Column A I have a values that are going to chage every month. In one month I can have 1000 rows in another 200 rows of values.

In Column B I'm going to have a formula on B1. I want to copy the formula down depending on the number of rows in Column A. I know I can use the AutoFill but I prefer to have a code that determines the range.

Can you please help??

Thanks in advance!!

[Leith Ross]

Hello JSoto,

Here is how to do it...

'Find the Last Row in Column "A"
LastRow = Cells(Rows.Count, "A').End(xlUp).Row

'Auto Fill Cells B2 to LastRow with the Contents of B1
Range("B1").AutoFill Destination:= Range("B2:B" & LastRow)

Sincerely,
Leith Ross

[JSoto]

This is great!! Thanks!!