Simple Copy and Paste Formula-Only Code|VBA & Macros|Excel Forum|My Online Training Hub

Hello,

This should be very simple but I lack VBA experience. I recorded a macro and then looked at the code it produced but I thought there might be a simpler way to change what I have, below.

Here's a line of code in my workbook:
Range("B1").Value = Range("B2").Value

This copies B2's value to B1.

I want to change this to copy B2's formula only (non-VBA: PasteSpecial/Formula) to B1. How should I rewrite this line of code?

Paul