T
Tendresse
I have 100 spreadsheets. I defined a range 'MyRange' (insert>Name>define) in
each one of them. 'MyRange' in all the spreadsheets starts in cell A13 and
ends somewhere in column D. so in Spreadsheet 1 it could be A13
30, in
spreadsheet 2 it could be A1350, etc.
I wrote a macro that will open each one of the 100 spreadsheets, copy
'MyRange' and paste it in a Master workbook. I now realised that i should
have included column E in my range as well .. so in spreadsheet 1 it should
be A13:E30, and so on.
I was going to open each one of the spreadsheets and expand the range
manually, but then i thought i already have a code that will open each one.
All i need is to add a line or 2 in there that changes the range and expands
it to include column E before it's copied and pasted.
How can i do that in VBA? I'm using Excel 2003.
I appreciate your help. Tendresse
each one of them. 'MyRange' in all the spreadsheets starts in cell A13 and
ends somewhere in column D. so in Spreadsheet 1 it could be A13
30, inspreadsheet 2 it could be A13
50, etc.I wrote a macro that will open each one of the 100 spreadsheets, copy
'MyRange' and paste it in a Master workbook. I now realised that i should
have included column E in my range as well .. so in spreadsheet 1 it should
be A13:E30, and so on.
I was going to open each one of the spreadsheets and expand the range
manually, but then i thought i already have a code that will open each one.
All i need is to add a line or 2 in there that changes the range and expands
it to include column E before it's copied and pasted.
How can i do that in VBA? I'm using Excel 2003.
I appreciate your help. Tendresse