I'm using the following in a macro script to copy the value of one cell to a new worksheet. Does anyone know how I can copy the value of the cell so that when the source cell has a formula it won't copy the formula, but will copy the value only?
Sheets(CurrSheet).Range("A4").Copy Destination:=Sheets(NewSheet).Range("A4")
Sheets(CurrSheet).Range("A4").Copy Destination:=Sheets(NewSheet).Range("A4")