Another parsing question

  • Thread starter Thread starter Tom C
  • Start date Start date
T

Tom C

Assume a user supplied excel cell formula of "=Model!E75" which could
change so I don't want to hard code it. Inside of a loop I need to
make it increment the row to refrence E76, E77, etc. Any suggestions
on a quick easy way to replace the 75 with the next value?

I know I could write a few lines of code but just wondering if anyone
has a slick one liner or so...

Thanks!
 
Well, you could use a combination of string.split and int.tryparse. The
problem is you say it could change and you don't want to hard code it. The
code would be very different if your formula was "=Avg(E75:G75)".
 
Back
Top