Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 417
Default Reference offset cell (Additional Instructions)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Offset Reference Cell Alex Mackenzie Excel Worksheet Functions 1 December 18th 08 06:38 PM
Repost: Copy and Offset cell reference CJ[_2_] Excel Worksheet Functions 1 September 5th 08 03:38 PM
How to reference an offset from a cell? poddys Excel Worksheet Functions 3 March 10th 06 08:24 PM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. [email protected] Excel Worksheet Functions 2 December 11th 04 12:05 AM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable [email protected] Excel Worksheet Functions 2 December 11th 04 12:00 AM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"