Greetings

I am constantly tweaking my spreadsheets. Everytime I add or subtract a row or colomn I have to rewrite the code to reflect these changes.

For example, The following code selects cell "B4" then deletes the contents.

Range("B4").Select
Selection.ClearContents
If I add a row or a column above, below or beside "B4" I have to change ("B4") to reflect this.

For example, if I insert a row in Column "A", "B4" would have to be changed to "C4".

Is there a way to write the code so that a I can make changes to the sheet without have to rewrite the code everytime?

any help would be appreciates.