Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a range of cells to all workbooks in a folder?
Hi all,
Can anybody please help... I have +100 workbooks that i need to change a named range in (all in a folder). Is there a way to amend all of them via vba? the thought of doing it all manually fills me with dread! ie. Unhide worksheet 'Data', replace range of cells A1:A5 with A, B, C, D, E and define/name this range as 'Option' and re-hide the sheet Any help whatsoever would be greatly appreciated. many thanks P :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy folder with excel linked workbooks | Excel Discussion (Misc queries) | |||
linking cells from workbooks in a folder | Excel Worksheet Functions | |||
Copy & Paste Range from all Worksheets in all Workbooks in a folder | Excel Programming | |||
Copy a cell to all workbooks within a folder. | Excel Discussion (Misc queries) | |||
Copy several range from all files in folder into several worksheets | Excel Programming |