Hi all,

I have been trying to write a macro that will do the following:

- Look to a specific folder in my home drive (nb this may change)
- select all of the excel files that are in that folder (100+)
- select various cells in each of those spreadsheets - each spreadsheet is formatted the same with the same structure. The cells are random, e.g. D6, I22, H4, K4, D17, so I cannot select a whole range. There are easily over 100 cells that I need to select
- copy these cells and paste them into one row of a spreadsheet ( that I have started the macro running from)

The problem that I keep coming across is selecting the various cells. If anyone has any suggestions then they would be greatfully received.