Solved: Problem in append data to next column

[tlchan]

Hi there,
I have 3 worksheet and I wanted to transfer my current data in sheet("Cards") column D Add to column E of the same sheet and at the same time append to next column A in sheet ("FY0809").

The button in sheet("reportdate") will run the macro for above task. However the data only appended in column B of sheet ("FY0809") instead of next column on every button pressed.

The macro works in VBE under run but failed in button click command. Anybody can assist me ?

Attach the sample workbook

[mdmackillop]

The relevant part only
[VBA]
Sub AddtoCul()
Dim NextCol As Range
Set NextCol = Worksheets("FY0809").Cells(1, 256).End(xlToLeft).Offset(, 1)
Worksheets("cards").Range("D559").Copy
NextCol.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False '
End Sub

[/VBA]

[tlchan]

It works perfectly. Thanks Md for your quick solution.