Apply concatenation formula to specified cells/column on wb open event

[Grilleman]

Hello again,

On page open event, how do I set all cells in column D (to row 101) to the concatenate formula in the last cell in column D containing data (formula)? See attached workbook.

Please Login or Register  to view this content.

Thank you

[TMS]

Try calling this subroutine from the Workbook_Open Event handler

Please Login or Register  to view this content.

[Grilleman]

Thanks! That worked.

[TMS]

You're welcome. Thanks for the rep.