How do I make the following code similar to absolute refrence in formulas.

[TBM]

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.

Please Login or Register  to view this content.

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.

[AliGW]

I believe you can use named ranges instead of cell references.

[TBM]

Thank you
I will have a go at it

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[TBM]

I know how to make named ranges. I do not know how to use them, in order to, allow the sheet to have rows or colomns added or subtracted without having to change my code.
Perhaps you could use the following "name range" in my example from my previous post.

the defined name is "TAPERbead"

the code is

Please Login or Register  to view this content.

Any help would be appreciated

[humdingaling]

you can avoid using select altogether

Please Login or Register  to view this content.

[FDibbins]

My VBA is weak, but I know there is a way to ID the active cell. Perhaps you could use that method, instead of using a hard-coded cell ref?

[humdingaling]

to be honest i would just declare the range at the start of the code
its easier to change it once at the start of the code then having to constantly re-code your whole work

ie

Please Login or Register  to view this content.

[TBM]

I went with humdingaling first idea.
it seemed simple enough.
worked great t

thank you

[FDibbins]

Im happy you found what you wanted, and thanks for the feedback