References include Visual Basic for Applications, Microsoft Excel 14.0 Object Library, Microsoft Forms 2.0 Object Library, Microsoft Office 14.0 Object Library and Microsoft Visual Basic for Applications Extensibility 5.3. I have tried it both ways and neither worked. I read somewhere else that Mac uses a period instead of a forward slash. You should get a succession of Day numbers, Day 2, Day 3, Day 4 etc appearing. Move the cursor to the right hand bottom corner of A1 until a thin black cross appears. I have tried the code below but it fails at SourceFile=Dir(myDir & '.*.xls) Re: Adding number to a succession of cells Put 'Day 1' in A1. From there I will copy the first four columns into another file and continue on with the my processing. If you’re using Excel 2003 you’re limited to numbers in the range 1 to 65,536, and if you’re using Excel 2007 onwards you’re limited to number between 1 and 1,048,576. It is therefore limited to the number of rows in your workbook. I want to have the user select from this directory the appropriate file. It uses the ROW function to generate a list of values that should be in Deborah’s range. I want to open the 'Finder' on a Mac to select from available Excel files. I have done this with Excel for Windows but it doesn't seem to work on a Mac.
