Returning Row Number For a Specific Value

[Simcha84]

Hello!

I'm currently teaching myself how to use VBA at work, as I track large amounts of data regularly. I ran into an issue while trying to collect specific keyword data. I'm trying to grab the row# that has the maximum value for the inserted range.

This is my code:

Please Login or Register  to view this content.

I'm really not familiar (probably very obviously so) with VBA. I learned a bit in an engineering class I took, but that's about it. Any suggestions or ideas on how to better return the values I'm looking for are greatly appreciated.

1) I have all my maximum, median, and minimum values
2) I want to find the keywords associated with those maximum, median, and minimum values
3) Those keywords are located in the same rows as my max, med, min values


Thanks,
Simcha

[mehmetcik]

Administrative Note:

Welcome to the forum.

I will reply once you comply with the Forum rules.

However please explain in words exactly what you want done. One step at a time.




We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[AlphaFrog]

Try something like this. Assuming the max value is in AG265

Please Login or Register  to view this content.