Hi
I am looking for some help here with the final part of my macro.
Basically i want to autofill a value in a column which I can do by recording a macro but the problem is that the number of rows will vary from account to account.
For the example autofill the number of rows was 21 but the number of rows will vary per account.
How can i do the same autofill but where it stops at the first blank row?
Thanks
Lee
I am looking for some help here with the final part of my macro.
Basically i want to autofill a value in a column which I can do by recording a macro but the problem is that the number of rows will vary from account to account.
For the example autofill the number of rows was 21 but the number of rows will vary per account.
Code:
Sub AutoFillNotification()
'
' AutoFillNotification Macro
'
'
Selection.AutoFill Destination:=Range("C2:C22")
Range("C2:C22").Select
End Sub
How can i do the same autofill but where it stops at the first blank row?
Thanks
Lee