Only perform macro if a cell from a specific range is selected (SOLVED)

**daivd_vachon** · 10-11-2012, 01:54 PM

Hello,

I have 2 problems with a specific macro I created. The macro creates a new worksheet that is a copy of my template sheet and renames it to the value in the original cell on my "Masterlist". My problem is I only want this to happen when a new item is entered in range("b11:b"). Right now it happens when you enter new text in any cell in the "Masterlist" sheet.

My second issue is when I delete an entry on the "Masterlist" it also creates a new copy and then renames it. How could I alter my code to avoid this.

Thank you for any help.

Dave

Please Login or Register  to view this content.

**jaslake** · 10-11-2012, 04:24 PM

Hi David

As to your first issue try this

Please Login or Register  to view this content.

**daivd_vachon** · 10-11-2012, 04:48 PM

Hi jaslake,

It doesn't seem to do the job. Also would it have worked with a range specified, for ex. b11:b or is it only for 1 cell. Also anyone idea as to my second problem?

Thanks for your time

**jaslake** · 10-11-2012, 04:55 PM

Hi David

My experience is quite limited but I don't know what range b11:b is...far as I know it's not a range...can you explain it to me?

The code I proposed is limited to one cell B11...it's why I asked the questions I asked...please respond.

Never mind...confused Threads. What exaclly is Range("b11:b")?

**daivd_vachon** · 10-11-2012, 05:12 PM

What I mean't was from cell B11 down to the bottom of column B sorry for the confusion. So if anything is entered in column B under B11 the macro will functions.

Thank you,

**jaslake** · 10-11-2012, 05:22 PM

Hi David

Are there any blank cells between B11 and the last filled cell in Column B? If not try this (untested)

Please Login or Register  to view this content.

**daivd_vachon** · 10-12-2012, 03:44 PM

Wow thank you jaslake, you solved both my problems A+

**jaslake** · 10-12-2012, 04:21 PM

Hi David

You're welcome...glad I could help.

PS: You marked you Thread as SOLVED incorrectly

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save