Replace cell values with Macro

C

C.S.Harris

I have a Macro that clears a form, and I want it to replace the cleared cells
with original information.
Here is a brief example of my code:

Range("P3,P4" _ ).Select
Selection.ClearContents

I want range P3, P4 to say "N/A" after it is cleared. Or better yet to just
replace the contents of P3,P4 with "N/A".

Thanks
 
D

Debra Dalgleish

This will replace the cell contents, on Sheet1, with "N/A"

Worksheets("Sheet1").Range("P3:p4").Value = "N/A"
 
Top