VBA FillDown vs. Autofill errors out

[BillTony]

Hi there,

I am having trouble (seemingly) with the syntax / usage of "FillDown" in the code snippet low.

I have a varying number of rows (number of rows added each day change drastically) in column C of a dataset.

I then have a unique numeric code that populates column B down to the last row in column C containing a value.

Next day, the process repeats.

However, the numeric code in column B must NOT increment.

The starting point for the new daily "add" is designated in the "Paste" section.

The line of code having the range of B66:B, etc. works - but obviously that requires a "static" or known start point.

The FillDown segmen that has the range containing "ActiveCell" is NOT functional - but that is really what I am seeking guidance on.

Any help is greatly appreciated!

'PASTE the COPIED VALUE.
    Range("B1").End(xlDown).Offset(1, 0).Select
    With Selection
    ActiveSheet.Paste
    End With


'Set the FILL DESTINATION.
    Range("B66:B" & Last_Row_ColC).FillDown
  
'Set the FILL DESTINATION.
    'Range(ActiveCell & Last_Row_ColC).FillDown

 

[Norie]

If you don't want the value in column B why not use something like this?

Range("B6:B" & Last_Row_ColC).Value= Range("B6").Value