I know how to use a macro to enter a value or text into a spreadsheet cell, but I'm more than a little hazy on how to do the opposite: use, say, a column of values (store numbers, employee names, etc.) as input TO the macro, to guide the macro into - for example - branching to various actions. (I'm remembering how I use to do this in 123v2.3; it was a snap. But I can't seem to figure out an equivalent capability in Excel).
The specific situation I have is that I am building a macro that will load downloaded text files from our G/L package into Excel, and convert them into Excel files (or tabs). I need a way to specify to the macro (without changing the macro each time) what file names I want it to load. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>