Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You need to have the worksheet that contains the data to be unwrapped
active when you start the macro. It will automatically insert a new worksheet, find all of the data areas and copy the data accordingly. I would put the code into a new, blank workbook, then attach a new toolbar to it that has a button (smiley face or something) on it. Then hide the workbook and save from the VBA editor. Then you can use the macro an any data workbook that is currently active (all 75 of them!). Reply to the newsgroup, if you need more detailed instructions. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Offset Reference Cell | Excel Worksheet Functions | |||
Repost: Copy and Offset cell reference | Excel Worksheet Functions | |||
How to reference an offset from a cell? | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |