Worksheet_Change

[Aland2929]

The following code runs the routine CommCalc. I would like CommCalc to run if another range in the same sheet changes. The other range name is "ActivityResult". Please advise how the code can be amended to include the range "ActivityResult".

Please Login or Register  to view this content.

Thanks in advance

[Aland2929]

I have entered the following code which seems to work but is there a better way to do it?

Please Login or Register  to view this content.

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

[Aland2929]

Thanks DonkeyOte, but I receive the following error message:
"Object variable or With block variable not set"

[DonkeyOte]

I omitted Is Nothing ... blame the error on the football I'm watching !

edit:

To be clear

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[sreenivas501]

Hello Friends,

I Need your help... please help me... below is the request..
Pivot table and it is filtered... Say in column A 1 to 50 and in column B 1 to 75 missing some numbers in in both columns... now I'm looking for a macro it should give me the matching numbers on in row and if not matching in A then in nothing in B..... in simple terms Apple to Apple match if both match else one or the other coumn is empty...

[Aland2929]

Thank You. Works Perfectly. Enjoy the game.

[DonkeyOte]

@Aland2929, no problem.

@sreenivas501, welcome to the board, however, please note:

Your post does not comply with Rule 2 of our Forum RULES.
Don't post a question in the thread of another member -- start your own thread.