If cell A1 contains a different cell reference (in my case it changes but will always be of the form B6, never $B$6 or B6:B9) can somebody help me with the VBA code syntax to enter some other data (always a strings eg "SUCCESS") into whatever cell A1 references at the time.