Hi there,
Just wondering if anyone could help me with the following problem:

Range("A240:G240").Select
Selection.Copy
Range("A241").Select
ActiveSheet.Paste
Range("A240:G240").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("A242").Select

Each time I run the macro, I want the row value to be increasing (i.e.
A240:G240 to A241 to:G240). Range A240-G240 refers to the value from
another sheet which has to be copied to the following row and then
paste the value to A240-G240 (no formulas).

If anyone could help, that would be really appreciated.
Thanks
AN