Need to limit the range of cells affected by code

**Rednecknerd** · 01-14-2015, 05:01 PM

When I click on a cell or double click on a cell that is already selected it changes the fill color.
That part works great.

But how do I limit it to the range B2:L30 ?
Or columns B:L ?

Either one works fine for me.

Thanks in advance for the help.

**Debraj Roy** · 01-14-2015, 05:13 PM

Enclose your old code within a IF block..

Please Login or Register  to view this content.

project tracking.xlsm

**Rednecknerd** · 01-14-2015, 05:27 PM

Thanks, that is perfect. Rep added.

Need to limit the range of cells affected by code

LinkBack

Thread Tools

Rate This Thread

Display

Need to limit the range of cells affected by code

Re: Need to limit the range of cells affected by code

Re: Need to limit the range of cells affected by code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Limit the range of code to prevent ambiguous name conflict

[SOLVED] Modif yWorksheet Selection Change code so that A4:T4 is not affected

[SOLVED] split the code while argument is not affected

Highlight Row - Limit the code to certain cells

Where to put VBA code so Excel Application is affected

Bookmarks

Bookmarks

Posting Permissions