I still can't get this to work. With your formula, all I am getting ar
the variables:
sStr = "Rxxxxnnnn"
sStr1 = "xxxnnnn"
How do I get this code to assign letters/numbers to these?


Here's what I have

A
RABC1001
RABC1987
RSRC1212
etc, etc, etc

What I have so far is:

Cells(i, 1).Select
RFileName = Selection

assigns RFileName = "RABC1001"

How can I make RFileName = "ABC1001" instead of "RABC1001" so I ca
loop through a file with the FileName column in "ABC1001 format????
Please help

--
hyyft
-----------------------------------------------------------------------
hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318
View this thread: http://www.excelforum.com/showthread.php?threadid=26105