Autofill text starting at the ActiveCell

Hi,

Can someone please help me rework the following macro. I am trying to insert text into the middle of a document. I need the macro to find the first open cell in column D, key in "Deposit Required" and carry that text only as far down as there are filled cells in column C. I know the problem lies in the last line of the code, but I'm not sure how to fix it.

Please Login or Register  to view this content.

Thanks!
canadian_chickie

What's your goal ? show me an example, before and after macro run

Sorry for the mess, I don't know how to format this so that it displays in proper columns

BEFORE:
ACCOUNT DESCRIPTION COMPANY ISSUE
11111-111 ABC TREATMENT ABC LTD OVERBILLED
11111-112 DEF TREATMENT DEF LTD OVERBILLED
11111-113 GHI TREATMENT GHI LTD MISSING SIGNATURE
11111-114 JKL TREATMENT JKL LTD
11111-115 MNO TREATMENT MNO LTD
11111-116 PQR TREATMENT PQR LTD


AFTER ("Deposit Required" has been added to the first empty cell in Col D and carried down only as far as there is a company in Col C):
ACCOUNT DESCRIPTION COMPANY ISSUE
11111-111 ABC TREATMENT ABC LTD OVERBILLED
11111-112 DEF TREATMENT DEF LTD OVERBILLED
11111-113 GHI TREATMENT GHI LTD MISSING SIGNATURE
11111-114 JKL TREATMENT JKL LTD DEPOSIT REQUIRED
11111-115 MNO TREATMENT MNO LTD DEPOSIT REQUIRED
11111-116 PQR TREATMENT PQR LTD DEPOSIT REQUIRED

attach the file

See attached
Report.xlsx

Please Login or Register  to view this content.

Thank you!!! You are a lifesaver patel45!!