Thread: Macro Referencing Text From Another Cell

Hi,

I'm having some trouble figuring this out, although it's probably an easy fix. I'm trying to create a macro that when run, will enter text specified in the code in a cell of my choosing, and enter other information at the end of the previously entered text pulled from a different cell. I've attached at example of what I'm trying to do to help clarify.

Thanks!
Kevin

Why not just use a formula like

="Inventory Database -"&RIGHT(D2,2)

or am I missing something

VBA Noob