sending text

[Arthur]

Pulling a value into a cell is easy.
But can you go the other way, ie, can you send text to
another cell and then have that cell be a value not a
formula? Or can you pull a value into a cell and then
immediately have that cell convert to the value (and not
remain a formula)?
-Arthur

 

[Ron de Bruin]

Use the value propety if you use a macro

Sub test()
Range("c1").Value = Range("a1").Value
End Sub

If you do it manual
copy a cell
choose Edit(menubar) paste special....Values

 

[Ron de Bruin]

Hi Arthur

We still wanted an automated cut and paste

Sorry you need macro's to do it

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

Ron,
The problem is that in my case the resulting sheet was
for other people to use and I'm told that people tend to
instantly distrust anything with macros in it and close
the file immediately for fear of damage that the file
might do. We wanted to avoid this problem by avoiding
macros.
We still wanted an automated cut and paste type
scenario across worksheets, keeping a history of values.
In other words, if a cell is unpopulated make it a value
[cell reference, whatever], but thereafter do not change
it.
-Arthur

-----Original Message-----
Use the value propety if you use a macro

Sub test()
Range("c1").Value = Range("a1").Value
End Sub

If you do it manual
copy a cell
choose Edit(menubar) paste special....Values

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)







.