change macro for selection column I

Hi everyone,
the attached macro works for all selected cells.

Please Login or Register  to view this content.

You can change it to work only for the sheet "PRC2" column I3:I1000
Thank you
john

Try this code,although untested since the last line is not an end sub(not complete sub)

Please Login or Register  to view this content.

Hi maniacb thanks you.
Error here:
rng = Range("I3:I1000")

This is hopefully working to your expectations.

Please Login or Register  to view this content.

No maniacb in not correct.
If I select example in sheet "PRC2" value AAA10 > button "TROVA/FIND"
in sheet "PRC1" the value AAA10 must be selected.

HI

try this..

Please Login or Register  to view this content.

zeddy

Hi zzeddy thanks you.
Your macro is almost exact but it should only work for column I sheet PRC2.
If a different column / cell is selected, it must give an error

Just change the ranges on this line from col A to col I

Please Login or Register  to view this content.

Fluff13 error:

error run time 91
variable or block object not set

Hi

A slight adjustment then..

Please Login or Register  to view this content.

zeddy
Excel Adjustment Bureau

error run time 91
variable or block object not set

In that case please post your modified code.

Hi zeddy work well.
is it possible to modify with new msgbox if in PRC1 there is no value as selected in PRC2?
john

For fluffy13
i changed the line as you say
error 91

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I misunderstood what you were trying to do, use the commented out line & it works fine.

Hi John

Re: is it possible to modify with new msgbox if in PRC1 there is no value as selected in PRC2?
Here's some adjusted code..

Please Login or Register  to view this content.

zeddy
Excel Triple-A Solutions

Hi zwddy work well.

'Dim zMatch As Worksheet correct is Worksheet?

Please Login or Register  to view this content.

Dim zMatch As variant

Hi protonleath
I tried your macro but it doesn't work correctly, selecting the cell sheet PRC2 doesn't show the same in the sheet PRC1
john