dim myCell as range
dim myRng as range

set myrng = worksheets("sheet999").range("a1:F1")

for each mycell in myrng.cells
'do your work
msgbox mycell.value
next mycell



Sandy wrote:

Hello
I have a list of *.txt files in A1:F1. I have already written code to
define the path where the file is located (myPath). I need to open each file
and perform some formatting and then copy to another file. How do I loop
through the files using the content of the range?
Thanks!

--

Dave Peterson