Hello People, THANK YOU for everyones help. Here is my question
tonight:

I have an array with a bunch of filenames in them, I want to modify the
file names to get rid of the extension ".gif".


FOR I = 1 TO .FOUNDFILES.COUNT
SCANMAPS(I, 1) = DIR(.FOUNDFILES.ITEM(I))
NEXT I


If it was in a Column I would do this:
Columns("A:A").Select
Selection.Replace What:=".GIF", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

How can I change the array without having to paste it in a row modify
it and put it back into the array?

Thank You in adavance


--
icdoo
------------------------------------------------------------------------
icdoo's Profile: http://www.excelforum.com/member.php...o&userid=27342
View this thread: http://www.excelforum.com/showthread...hreadid=501422