Hi,

I want to populate an array with the first 4 digits of an 8 digi
code.
But what is the VB syntax for Left(), not Left as a worksheet formula.
This is my example:

For i = 1 to usedrow
Code(i)=Range("a1").offset(i,0).Left( ?, 4) ' What can i writ
here
Next i

Any suggestions will be greatly appreciated

--
erikh
-----------------------------------------------------------------------
erikhs's Profile: http://www.excelforum.com/member.php...fo&userid=3278
View this thread: http://www.excelforum.com/showthread.php?threadid=56698

Left is a function in VBA, not a method. The format is the
same as for the worksheet function:

Code(i) = Left(Range("a1").Offset(i, 0), 4)



erikhs wrote:
Hi,

I want to populate an array with the first 4 digits of an 8 digit
code.
But what is the VB syntax for Left(), not Left as a worksheet formula.
This is my example:

For i = 1 to usedrow
Code(i)=Range("a1").offset(i,0).Left( ?, 4) ' What can i write
here
Next i

Any suggestions will be greatly appreciated.


--
erikhs
------------------------------------------------------------------------
erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788
View this thread: http://www.excelforum.com/showthread...hreadid=566985

Code(1) = left$(range("a1").Offset(i,0),4)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"erikhs" wrote in message
...
|
| Hi,
|
| I want to populate an array with the first 4 digits of an 8 digit
| code.
| But what is the VB syntax for Left(), not Left as a worksheet formula.
| This is my example:
|
| For i = 1 to usedrow
| Code(i)=Range("a1").offset(i,0).Left( ?, 4) ' What can i write
| here
| Next i
|
| Any suggestions will be greatly appreciated.
|
|
| --
| erikhs
| ------------------------------------------------------------------------
| erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788
| View this thread: http://www.excelforum.com/showthread...hreadid=566985
|

Works great! Thank you very much

--
erikh
-----------------------------------------------------------------------
erikhs's Profile: http://www.excelforum.com/member.php...fo&userid=3278
View this thread: http://www.excelforum.com/showthread.php?threadid=56698