VBA copy and paste value

[mulanfox]

I wish to copy the value from column A to column B with the condition only value from column A is copy to column B, value of column A is removed without removed or changing in any formula in column A. Currently i only achieved to copy from column A to column B but value at column A still remain. how do i should coding in VBA

How to coding the undo at user form??

anybody can help me..


i uploaded a file for ur concern

[Paul]

Hello mulanfox, welcome to the forum.

To copy and paste only values elsewhere, you use PasteSpecial. For example:

Please Login or Register  to view this content.

[mulanfox]

Hello mulanfox, welcome to the forum.

To copy and paste only values elsewhere, you use PasteSpecial. For example:

Please Login or Register  to view this content.

but how do i clear the data without remove its formula??

[Paul]

What do you mean clear the data? A formula is a formula. If it results in something, it shows it to you.

You can show nothing in a formula by setting it to "" in an IF statement, for example..

=IF(A1*B1>10,"Yes","")

But I'm not aware of a way to do what you're asking if I'm understanding you correctly. Maybe explain it better, or provide a sample workbook explaining it.

[mulanfox]

What do you mean clear the data? A formula is a formula. If it results in something, it shows it to you.

You can show nothing in a formula by setting it to "" in an IF statement, for example..

=IF(A1*B1>10,"Yes","")

But I'm not aware of a way to do what you're asking if I'm understanding you correctly. Maybe explain it better, or provide a sample workbook explaining it.

actually is like that.. the value at column A is from sheet2 which i perform all the calculation. the value later by link to sheet1 column A. when a new calculation at sheet2 is done it automatically link to sheet1 column A. but i wan clear the value without clear the link when i use macro to remove to next column

[mulanfox]

actually is like that.. the value at column A is from sheet2 which i perform all the calculation. the value later by link to sheet1 column A. when a new calculation at sheet2 is done it automatically link to sheet1 column A. but i wan clear the value without clear the link when i use macro to remove to next column

file has been uploaded...

[mulanfox]

online i found before example but it not work..somebody please help me
Sub Clear_Range()
Dim myRg As Range
Dim vRg As Range

Set myRg = Range("A4:GZ67")

On Error Resume Next
Set vRg = myRg.SpecialCells(xlCellTypeConstants, 23)
If Err = 0 Then
vRg.ClearContents
End
Else
Set myRg = Nothing
Set vRg = Nothing
MsgBox "No values, or values already cleared!"
End If