Change cell value and macro runs

**Macdave_19** · 11-21-2007, 06:34 AM

Hi folks i'm having trouble getting this code to work!! i would like certain cell values to change when i update the range B4 but i don't know quite how to set the range as b4?

any help is much appreciated, here is my code

Please Login or Register  to view this content.

Thanks for taking the time to view my thread everyone and for any help

**StephenR** · 11-21-2007, 07:44 AM

Your syntax isn't quite right, but I don't follow. You appear to be setting SAgent to equal Target (B4) but the second If only works if Target doesn't equal SAgent which by definition cannot happen?

Please Login or Register  to view this content.

**Macdave_19** · 11-21-2007, 10:41 AM

OK so lose the contradiction in there and im still left with:

Please Login or Register  to view this content.

**BigBas** · 11-21-2007, 10:58 AM

Are you asking how to make a change if the target is cell B4?

If so, try this code:

Please Login or Register  to view this content.

Otherwise, I'm not sure what you are asking.

**stevekirk** · 11-21-2007, 10:58 AM

hi Macdave_19,

is the idea of this macro to change all the cells in the range to what is in b4 ?

steve

**Macdave_19** · 11-23-2007, 04:09 AM

Yes steve it is mate!!

**stevekirk** · 11-23-2007, 04:18 AM

hi

are you having problems with the code you last posted ?

the reason i ask is because i wanted something like this and it works for me

steve

Change cell value and macro runs

LinkBack

Thread Tools

Rate This Thread

Display

Change cell value and macro runs

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions