Results 1 to 5 of 5

Thread: Storing row numbers

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Storing row numbers

    Hello! I have a sheet that looks like this:

    Capture.jpg

    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.
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •