Macros Runtime Error

[questforexcel]

Hi,

I have been trying to run macros from my source file to run on my target file.

I even selected use "relative reference", however every time I start to work on my file it gives me a runtime error code 1004. I understand that is because it cannot source the reference data. When I debug, it opens VBA and higlights the cells in blue below.

Could you please help and guide on whats wrong with my code and Macros.

I am fairly new with it, it doesnt appear to be as simple as clicking a "start" recording and "stop" recording macro.

End With
ActiveCell.Offset(2, 0).Rows("1:4").EntireRow.Select
Selection.Delete Shift:=xlUp
ActiveCell.Offset(-2, 0).Rows("1:5").EntireRow.Select
ActiveCell.Offset(-2, 9).Range("A1").Activate

 

[Fluff]

What is the active cell to start with?
If it's in row1 or 2 you will get an error

 

[questforexcel]

Hi,

The active cells were in Row 2. Is there a set defined number of rows columns which should be left while working on Macros.

Thank you

What is the active cell to start with?
If it's in row1 or 2 you will get an error

 

[Fluff]

With your code after the rows are deleted rows 4:7 will be selected
The next line will select rows 2:6
& the final line will try to move up 2 rows taking you to row 0 which doesn't exist.
What are you trying to do?