Can someone interpret this line of code please?

[BrianExcel]

I have this line of code that seems to work in some modules but not in others. Can someone please tell me (in plain English) what the "-1" means in this line of code?

sDates = Right(daterangeballpractice, Application.WorksheetFunction.Find(" ", daterangeballpractice) - 1)

Any thoughts? The "Date Range" cell I am referencing has different values in it so I need to basically search right of a dash (-).

Thanks!

 

[FracinDean]

I have this line of code that seems to work in some modules but not in others. Can someone please tell me (in plain English) what the "-1" means in this line of code?

sDates = Right(daterangeballpractice, Application.WorksheetFunction.Find(" ", daterangeballpractice) - 1)

Any thoughts? The "Date Range" cell I am referencing has different values in it so I need to basically search right of a dash (-).

Thanks!

Well it took several threads before I found one where I thought I could help. Thanks for the question.

In this code, the "-1" is just being subtracted from the result of the find function to calculate how many characters at the right of the string named "daterangeballpractice" to keep.

Example, date range ball practice is 50 characters long. The first blank space " " is at character 27, so "sDates" will equal the last (27-1)=26 characters from that string.

 

[FracinDean]

But if it's a dash you are looking for, then change the characters " " to "-" in the code.

 

[BrianExcel]

Thanks Fracin. I figured it was relatively easy but I didn't know how to say it in plain English, lol.