I am a new user of macros. Excel 2002.
I need to select all cells in a range from cells A2:L2 down to the last row
in column active cell in column A. The number of active cells in Column A
varies in the 35 worksheets I have to gather information from. I then need to
paste the contents into another workbook. Any suggestions would be welcomed.
TIA