Delete selection based on a differnt worksheet row.

[hmaveal]

Not sure if I can even do this. I have a sheet1 with current materials.
Once I used the materials and want to delete the row I would like a macro to go to another spreadsheet and delete a range before the sheet1 row deletion.

e.g. Cell E5 in sheet1 is going to be deleted. I need cells R5:T5 deleted from sheet2 before the sheet1 row is deleted. It will always be the same row as sheet1 and always the same columns on sheet2.

So.... 1. Select a row on sheet1 (remember it) (X)
2. Go to the same ROW on sheet2 and clears contents of R(x):T(x)
3. Return to the original row on sheet1 and delete the row.


any help at all is appreciated.

 

[MrKowz]

Try:

Public Sub hmaveal()
Dim rRow As Long
rRow = ActiveCell.row
Sheets("Sheet2").Range("R" & rRow).Resize(1, 3).ClearContents
Sheets("Sheet1").rows(rRow).Delete
End Sub