Question: I've got a string with numbers and text, and I need to find in that string a number that always starts with "9" and has a length of 8 numbers. How should I do it?

For example: 

```
"customer 92345678 and customer 9234"

```

Thanks!

Answer: 
> 
> *How can I pass a range of values?*
> 
> 
> 

You don't. You can't put 3 cell values in 1 slot. You want `[B1:B3]` in 3 slots, so inside your 0-2 loop you'll take the cell in column `B` at row `j + 1` - I had a hard time formatting that ID string in the code block, so I extracted it into its own variable; it also makes the assignment instruction a bit clearer:

```
Dim id As String
id = "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I"

For j = 0 To 2
    session.findById(id & "[1, " & j & "]").Text = sht.Range("B" & j + 1).Value
Next j

```
If you create a sum, you can transfer it to SAP.

for example:

session.findById("wnd[1]/usr/tabsTAB\_STRIP....ctxtRSCSEL\_255-SLOW\_I[1," & Int(j) & "]").Text = xcl.WorksheetFunction.Sum(sht.Range("B1:B3"))

Regards,
ScriptMan