PasteSpecial Constant

[Guest]

When using this function : Selection.PasteSpecial
Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

How do I change it to past a Public Constant?

 

[Guest]

Activecell.value = constName
where you replace constName with the name of the constant

 

[Guest]

Thanks Kassie, worked like a champ.

 

[Guest]

My pleasure!

 

[JE McGimpsey]

One caveat:

Instead of ActiveCell, to be fully equivalent, one should use Selection:

Selection.Value = constName

since in the OP's example, Selection could involve multiple cells.