Goto particular row number as per value in a cell

[pulvi]

How can we go to particular cell as per the value in a cell... what can the vba code for this be.... Please refer my attached file for clear understanding of the problem....

[Ed_Collins]

Try this. Two lines of code.

gotorownumber - modified.xlsm

[Tinbendr]

See if this is what you're looking for.

[Ed_Collins]

Ah. You want to goto the Z column.

Modified:

gotorownumber - modified.xlsm

[Marcol]

Without the need for buttons use the Workheet_Change event

In the Sheet Module

Please Login or Register  to view this content.

[Ed_Collins]

Without the need for buttons use the Workheet_Change event

In the Sheet Module

Please Login or Register  to view this content.

That's probably the best solution of them all.