Hi Im new to Macros and VBA so this may be obvious
I have just edited a recorded macro that copies various ranges of cells from on sheet to another (pasting them into different cells according to the resuld of a Vlookup) IT workef fine before but when a changed the range i got the error in the title.
HEres the code
The old code just missed out cell m6 so the orginal second qouted range was (F6:l6) the the select copy paste bit repeated for cell n6.
At first after i made the change nothing was being paste to M6 on the summary sheet but was all the other cells in the range. I rebooted the machine and I get the error also if I hit debug I get an exception violation and excel crashes.
Thanks
Squal
I have just edited a recorded macro that copies various ranges of cells from on sheet to another (pasting them into different cells according to the resuld of a Vlookup) IT workef fine before but when a changed the range i got the error in the title.
HEres the code
Code:
Sub Macroupdatedependencyrecord()
'This Macro updates the dependecies from the dependency file in the directory
'Written by Jon Waller on 15/9/03
Range("d2").Select
Selection.Copy
Sheets("filler").Select
Range("E6").Select
ActiveSheet.Paste
Range("C6:d6").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Summary").Select
Range("indirect(f2)").Select
Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Filler").Select
ActiveSheet.Range("f6:n6").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Summary").Select
Range("indirect(g2)").Select
Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
The old code just missed out cell m6 so the orginal second qouted range was (F6:l6) the the select copy paste bit repeated for cell n6.
At first after i made the change nothing was being paste to M6 on the summary sheet but was all the other cells in the range. I rebooted the machine and I get the error also if I hit debug I get an exception violation and excel crashes.
Thanks
Squal