macro to copy range data from another workbook

S

steven_thomas

I am havng trouble with my macro ... the macro tries to activate a 2n
workbook and copy some data from it ... the problem seems to be that m
range statement is not correct ... help ??? ...


Dim number As Range
Set number = Range("c1")


'Hazard Risk Upload
Workbooks("Risk Register Assessment and Control Plan Too
v16.xls").Worksheets("Data Upload").Activate
Range("A178:A294").Select
Selection.Copy

Workbooks("Risk Assessment Tool Master Roll U
v1.xls").Worksheets("RAT Data Upload").Activate
Range("a55").Select
For counter = 1 To 240
If counter <= number Then
ActiveCell.Offset(0, 1).Activate
End If
Next

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone
SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = Fals
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

range class error 2
Copy Multiple Areas from One Workbook to Another 4
Copy user selected range from all open workbooks 2
Help making this macro dynamic :) 1
Copy Range from Open Workbook to Active Workbook 0
Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
Copy data from another workbook to any open workbook 3
Copy range from one workbook to another 4

Top