Excel Macro

  • Thread starter Thread starter Mac
  • Start date Start date
M

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.
 
Perhaps more information??

Looking at the macro code would help alot...

Cheers
Juan
 
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
 
Back
Top