VBA Code

DoubleEntry

Hi All
Can anyone help with an excel VBA problem i have?

In column A I have a list of names. I have named A1 as range and use this to open another file, do some copying and pasting and then close. Now I need to loop down col A to do the same for A2 and so on, but hit a wall when the code goes back to the range for opening the next file, as it is still showing the name connected to A1.

Is there some way of naming the entire col A as the range but going through them one by one?

Any help is much appreciated.

Thanks

bluesnake

Not vba, but think this could be got working using something like EZmacros

esuhl

I haven't used VBA for ages, but rather than specify named ranges, why not refer to the cells by row & column ordinates? Then you can use a variable for the row number and a for loop to iterate through each one.

If you do a quick web search, there are examples of small functions you could write to identify the last populated row/column in a worksheet, which could be used as the upper bound in the for loop, if necessary.

DoubleEntry

Thanks for the replies - I have found a solution which is similar to esuhl's suggestion.

Cheers