| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteSpecial Constant
When using this function : Selection.PasteSpecial
Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False How do I change it to past a Public Constant? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PasteSpecial Constant
Activecell.value = constName
where you replace constName with the name of the constant -- Hth Kassie Kasselman Change xxx to hotmail "Rick" wrote: When using this function : Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False How do I change it to past a Public Constant? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PasteSpecial Constant
Thanks Kassie, worked like a champ.
"Rick" wrote: When using this function : Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False How do I change it to past a Public Constant? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PasteSpecial Constant
My pleasure!
-- Hth Kassie Kasselman Change xxx to hotmail "kassie" wrote: Activecell.value = constName where you replace constName with the name of the constant -- Hth Kassie Kasselman Change xxx to hotmail "Rick" wrote: When using this function : Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False How do I change it to past a Public Constant? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
PasteSpecial Constant
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. In article , kassie wrote: Activecell.value = constName where you replace constName with the name of the constant -- Hth Kassie Kasselman Change xxx to hotmail "Rick" wrote: When using this function : Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False How do I change it to past a Public Constant? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vba constant value for "Unicode Text" in PasteSpecial function | Excel Worksheet Functions | |||
| Why need to use Selection.PasteSpecial vs myRange.PasteSpecial | Excel Programming | |||
| Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
| PasteSpecial | Excel Programming | |||
| vba pastespecial | Excel Programming | |||
Linear Mode
