Copy paste!!!!!!!!!!

[DPK]

hello friends.!!!!!!!


How can I copy Excel's Cell value and paste it in another CELL.

I have to copy in range like
copy(range(a1:d1))

and then paster like
paste(range(a3:d3))

I need help ......

thanks in advance!!!!!!!!

[DPK]

anyone to help here with VBA????????????

[SammyB]

hello friends.!!!!!!!


How can I copy Excel's Cell value and paste it in another CELL.

I have to copy in range like
copy(range(a1:d1))

and then paster like
paste(range(a3:d3))

I need help ......

thanks in advance!!!!!!!!

If the ranges are the same size, you can just do "source.Copy destination" for example

Range("A1:D1").Copy Range("A2:D2")

but since you want to transpose, you must do a copy and then a PasteSpecial, Transpose just like you would manually in Excel. In code, this looks like:

    Range("A1:D1").Copy
    Range("A3:A6").PasteSpecial Paste:=xlAll, Transpose:=True
    Application.CutCopyMode = False

The way to figure this out is to record a macro, doing the operation, and then look at the code. HTH --Sam

[DPK]

I soved my problem.
Thank Yoy very much SammyB!!!!!!!!!!!
:-)

If the ranges are the same size, you can just do "source.Copy destination" for example

Range("A1:D1").Copy Range("A2:D2")

but since you want to transpose, you must do a copy and then a PasteSpecial, Transpose just like you would manually in Excel. In code, this looks like:

    Range("A1:D1").Copy
    Range("A3:A6").PasteSpecial Paste:=xlAll, Transpose:=True
    Application.CutCopyMode = False

The way to figure this out is to record a macro, doing the operation, and then look at the code. HTH --Sam