Find and activate first cell on currrent row containing...

[jeppenedved]

Hi!
I have a a specific value in column D, and the same valuein columns AI to CU. I want a button on every row, to find and select the first cell between AI and Cu, on the row the button is placed, that contain the same value as in column D. How would that macro look like? Thanks!

EDIT: Perhaps I should have mentioned that the value in the columns between AI and CU is returned by a formula more or less copying the value from column D.

[kev_]

This is easier than inserting a button on every row
- after adding code simply Right-Click in column D to see if that value is found
- looking for an EXACT match

Put code in sheet module
right-click on sheet tab \ select View Code \ paste code into code window \ {ALT{F11} to go back tio Excel

Please Login or Register  to view this content.

[mehmetcik]

The Approach is all Wrong.

1. You need an unspecified number of rows and therefore buttons.
Programming for that and creating the buttons would be a nightmare.

All that can be avoided by using all cells in a specified column as if they were buttons.

Right Click on your sheet name at the bottom of excel and select view code.

Paste this code into the module that opens and close it.

Please Login or Register  to view this content.

2. Click on any cell in column D
The Macro will select the matching cell on the same row within columns AI and CU.

Please Login or Register  to view this content.

[jeppenedved]

Awesome! You just saved me a whole bunch of hours putting in button to about 300 rows! Much appreciated, thanks!