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)".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing through HTML 7
Excel Help to copy information from one row at a time to another sheet 1
Change File Properties for Music Folder 4
Mail clients with servers? 0
Data manipulation Question 6
Parsing XML 13
Parse shortcuts (LNK files)? 6
Execute Existing Query Programattically 3

Back
Top