kurtwagner
New Member
- Joined
- Oct 27, 2012
- Messages
- 14
Hello! I have a sheet that looks like this:
I need to do graphs through VBA with it, but for that I need to store the row numbers of the years. For example, if I want to find the row values of the years exactly below "Parameter 1" to put as the graph range, how should I do it? It needs to be considered that the number of years below each parameter will change with time, so I was thinking of using as first year the first cell under the desired "parameter" and then looking for the number of the row of the first cell under it with a year that equals B2.
I need to do graphs through VBA with it, but for that I need to store the row numbers of the years. For example, if I want to find the row values of the years exactly below "Parameter 1" to put as the graph range, how should I do it? It needs to be considered that the number of years below each parameter will change with time, so I was thinking of using as first year the first cell under the desired "parameter" and then looking for the number of the row of the first cell under it with a year that equals B2.
