Excel Macro

[Mac]

I have created an excel macro. When I run it I get the
cell title instead of the value I have run this macro
before with no problems. Any Help??
ex:
VPN # 0911062 ABERJONA NURSING CENTER, INC. 2080
vpn name 7310.2 4306.1 7311.2 5105.1 7312.2
vpn name 7310 4306 7311 5105 7312
vpn name 7310 4306 7311 5105 7312

Top line is the data I want pasted in the cells but I am
getting the titles.

 

[Juan Sanchez]

Perhaps more information??

Looking at the macro code would help alot...

Cheers
Juan

 

[Guest]

Here it is . I have used it for many tasks but for some
reason it just paste titles
Sub DataList()
For Count = 1 To 2
RowO = Count + 1
RowN = Count + 2
Sheets("HCFLIST").Select
OldLink = "h:\rsc\rsc2003\" + Cells(RowO, 2)
+ ".XLS"
NewLink = "h:\rsc\rsc2003\" + Cells(RowN, 2)
+ ".XLS"
ActiveWorkbook.ChangeLink Name:=OldLink, NewName _
:=NewLink, Type:=xlExcelLinks
Application.Goto Reference:="AvgWage"
Selection.Copy
Cells(RowN, 1).Activate
Selection.PasteSpecial Paste:=xlValues,
Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Next
End Sub

 

[Guest]

Never mind I was asking for wrong row. Thank you for your
help.