S
spreadsheetlady
Hi,
If A1 is not blank then Copy A1 and Paste in A2:A7.
I originally had simple links in cells A2:A7 that connected to A1. But
sometimes one of the cells in range A2:A7 may manually have a value typed in
them, which erases the link to A1.
I thought trying this using VBA would eliminate the cell linkage loss.
I'm new to VBA.
Any suggestions would be appreciated.
Amy
If A1 is not blank then Copy A1 and Paste in A2:A7.
I originally had simple links in cells A2:A7 that connected to A1. But
sometimes one of the cells in range A2:A7 may manually have a value typed in
them, which erases the link to A1.
I thought trying this using VBA would eliminate the cell linkage loss.
I'm new to VBA.
Any suggestions would be appreciated.
Amy