Clear data in a cell using a macro

[jarrodexcel]

Trying to use a macro on excel to clear a column of data containing data, for example B2 down to B1500.
I need it so when i click the macro it will clear this selection.
Problem is i have another macro doing this on sheet two.
But i cant work out how to set up two macros doing the same thing on different sheets, when i try it overrides the other macro and inputs the same data.

Columna to delete data on sheet one is I2 - I 1500
Column on sheet 2 is B2-b1500


Any help would be appreciated. Thanks a bunch.

 

[Candyman8019]

It should be simple to specify which sheet each macro is applicable to. Can you share your macros so that we can assist you?

 

[DanteAmor]

Try:

Sub ClearArea()
  Sheets("Sheet1").Range("I2:I1500").ClearContents
  Sheets("Sheet2").Range("B2:B1500").ClearContents
End Sub

 

[jarrodexcel]

Try:

Sub ClearArea()
  Sheets("Sheet1").Range("I2:I1500").ClearContents
  Sheets("Sheet2").Range("B2:B1500").ClearContents
End Sub

Thank you mate, working a charm now!!