Cut / Paste poblems !!

[DaveUK]

Please advise.

I need to copy the activecell, which is in column A, to the cell in column Q on the same row and paste the values only on a worksheet "Temp Works" on the next empty row down. There is a header in row 1.

TIA

 

[babycody]

Copy your range. Then go to the sheet you wish to paste into. right click in the left most cell of the new range, and choose Paste Special and then choose values. I hope this is what you needed.

 

[DaveUK]

Thanks for taking the time and effort !!

I am actually looking for a VBA solution to this problem.

Regards

 

[nbrcrunch]

Hi Dave. Nothing in your post indicated you were looking for VBA solution.

So if you record the steps once (using the macro recorder), you'll have a recorded macro. Once there, you can alter it if you need to.

 

[Yogi Anand]

Thanks for taking the time and effort !!

I am actually looking for a VBA solution to this problem.

Regards

Hi DaveUK:

Try ...

        ActiveCell.Copy
        Cells(ActiveCell.Row, 17).PasteSpecial
        Sheets("temp").Cells(WorksheetFunction.CountA(Sheets("temp").Range("a:a")) + 1, 1).PasteSpecial Paste:=xlValues
        Application.CutCopyMode = False