Replace cell values with Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C.S.Harris - 13 Jan 2007 18:20 GMT

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

Reply to this Message

Debra Dalgleish - 13 Jan 2007 18:46 GMT

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

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

> I have a Macro that clears a form, and I want it to replace the cleared cells
> with original information.
[quoted text clipped - 7 lines]
>
> Thanks

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

C.S.Harris - 13 Jan 2007 23:16 GMT

Thank you, why was that so hard for me to find anywhere else?

> This will replace the cell contents, on Sheet1, with "N/A"
>
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message