Cut/Paste values in excel with VBA

[nando88]

I am trying to make a function to cut/paste values from a cell I will to specify in function to another cell I wioll also specify in function.
I tried:

Function Cortar(a As Rannge, b As Range)
Dim a As Range
Dim b As Range
Selection.Cut
    a.Select
    b.Paste
End Function

But I am getting invalid function.
I know this is simple, but I am a beginner in vba, and can not figure it out.
If someone could please help me, I would really appreciate it.

 

[Caleeco]

Hello Nando,

It's great that you've dived into the world of VBA :D I hope you stick at it as its a very powerful tool.

I have laid out the general construct of a Sub/Function - Cut/Paste routine.

Sub Main_Code()
Dim Range1 As Range
Dim Range2 As Range

Set Range1 = ActiveSheet.Range("A1")
Set Range2 = ActiveSheet.Range("A2")

Call Cortar(Range1, Range2)

End Sub



Function Cortar(A As Range, B As Range)
A.Cut B
End Function

Should be fairly self explanatory but let me know if you have any questions
Thanks
Caleeco

 

[nando88]

Thanks for responding.
I used your code and it gives me an a\error saying invalid function.
Maybe I am not typing it right:

=cortar(a1,b1)
//a1 contains data and b1 is where I want to paste

 

[Caleeco]

Ahhh right! Sorry, I misunderstood.

I thought you just wanted a VBA function and not a Excel Worksheet function. I've not done a copy/paste worksheet function before

Let me go away and try a couple things
Thanks

Caleeco

 

[Joe4]

I am a bit confused as to what you are trying to accomplish here.
Functions are typically used to return a value, not move things around. You would typically use a Sub Procedure in VBA to move things around.
All that entering formulas in Excel sheets can do is return a value to that particular cell that the formula resides in. You cannot have a formula in an Excel cell return a value to a different cell, nor can it "move" anything.

So what is it that you are really looking for? It sounds to me like you want a Sub Procedure in VBA to move a cell. You would have to feed it the ranges you want to move. You could either do that via another VBA procedure, or you could have it prompt the user to enter the ranges when you call the code to run.