Hi all, if I have a simple formula such as =a1, can I use VBA to update it to a2?

Would really appreciate the help