Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro & runtime problem
Hi,
I have a macro as shown below: Dim x As Long x = Application.WorksheetFunction.Match(ActiveSheet.Ra nge("AT1") _ , Worksheets("Wall data").Range("B:B"), 0) Worksheets("Wall data").Cells(x, 17).Value = ActiveSheet.Cells(1, 47).Value Worksheets("Wall data").Cells(x, 18).Value = ActiveSheet.Cells(2, 47).Value Worksheets("Wall data").Cells(x, 19).Value = ActiveSheet.Cells(3, 47).Value Worksheets("Wall data").Cells(x, 20).Value = ActiveSheet.Cells(4, 47).Value Worksheets("Wall data").Cells(x, 21).Value = ActiveSheet.Cells(5, 47).Value Worksheets("Wall data").Cells(x, 22).Value = ActiveSheet.Cells(6, 47).Value Worksheets("Wall data").Cells(x, 24).Value = ActiveSheet.Cells(8, 47).Value Worksheets("Wall data").Cells(x, 23).Value = ActiveSheet.Cells(7, 47).Value Worksheets("Wall data").Cells(x, 25).Value = ActiveSheet.Cells(10, 47).Value Worksheets("Wall data").Cells(x, 26).Value = ActiveSheet.Cells(9, 47).Value Worksheets("Wall data").Cells(x, 27).Value = ActiveSheet.Cells(11, 47).Value End Sub I can run it OK from my PC, but one of my colleagues gets the following message when he tries to run it: Run Time error 1004 Unable to get MatchProperty of the worksheet function class Can anyone please advise what this message means and/or what isn't happening? Cheers Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
JB Bates' Runtime Error 1004 problem | Excel Discussion (Misc queries) | |||
Runtime error in Macro. | Excel Discussion (Misc queries) | |||
Runtime error textbox problem - help required | Excel Programming | |||
Coding problem: Runtime 1004 | Excel Programming | |||
RunTime code problem | Excel Programming |