$$Excel-Macros$$ Re: Looping Through Selection and Writing to Another Spreadsheet - Transposed

2009-09-21 Thread Rob
Daniel, Thank you for the suggestion, but I am not sure where the file is that you are suggesting I look at. I have the following code, but it does not seem to work: Set Source = Range(Cells(3, 10), Cells((LastRow + 1), LastColumn)) X = 1 Y = 1 ReDim Data(Source.Count) LastColumn = Acti

$$Excel-Macros$$ Re: Looping Through Selection and Writing to Another Spreadsheet - Transposed

2009-09-18 Thread Daniel
Hello. Have a loop at the attached file. The macro "test" does the trick. Regards. > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of rdavis7...@gmail.com > Sent: jeudi 17 septembre 2009 18:29 > To: MS EXCEL AND VBA MACROS >