VBA Copy and Paste Variable Range

[CW Moss]

Can someone please help with this senario?

I have data in columns A, B and C. First row is a header.

The data in A and B does vary from week to week. But the two columns are always the same range.

The data in C is only takes one cell which is a date in C2.

I would like to copy C2 and paste it starting at C3 and end at the last row that A and B data ends. For example the last row for A and B data is A500 and B500 then copy C2 and paste from C3 to C500.

Remember A and B can be 500 rows one week or can be 557 the next week as this range varies.

I cannot use a fixed range of which I have already figure out how to accomplish.

I do need a solution to paste to a number of rows dependent on the range of A and B.

Thanks in advanced for your assistance

 

[BOGIA]

hi,

try this code:

Sub test()

Dim i As Integer

lastrow = ActiveSheet.UsedRange.Rows.Count

For i = 3 To lastrow
    If Cells(2, 3) <> "" Then
       Cells(i, 3) = Cells(2, 3)
    End If
Next i
End Sub

cheers bogia

EDIT: added code tags - try to use 'em - Moderator

 

[CW Moss]

Thanks Bogia, your code did the job!