Excel VBA using Range with variables

Question

I am trying to clear a range of cells with the use of a variable. For some background I have values in A-G that will be updated regularly while the values in I-K need to remain constant.

I am trying to use the value stored in myCell (in this example A8) to guide my clear command to be everything from it to G100

Range(myCell, "G100").ClearContents

I have tried several variations of this but it never seems to take so there must be something I am missing.

Thanks for looking!

SJR · Accepted Answer · 2018-01-12 17:06:21Z

2

You're close.

Range(myCell, range("G100")).ClearContents

answered Jan 12, 2018 at 17:06

SJR

23.1k6 gold badges21 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA using Range with variables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related