Re: how do the macros get data from te reference tables?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Mario

Data can be in hidden worksheets or hidden ranges.

Check the formulas you can see to find out what sheets and ranges they
reference.

Also check out Insert>Names>Define to see if you have names for ranges that may
be hidden.

If data not personal or sensitive, send me the file and I'll have a look at it.

To email me change the AT and DOT to the appropriate punctuation.

Do not attach files in postings to the news group.


Gord

On Thu, 19 Jan 2006 15:31:02 -0800, "Kitchen Tune Up - Mario"
<KitchenTuneUpMario@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Thanks for the response. We are trying to unhide the referencetables from an
>internal quoting program at our company that is in Excel format. We want to
>change some of the values .
>"Gord Dibben" wrote:
>
>> Do you have a specific workbook in mind or just in general.
>>
>> Are you sure you have macros?
>>
>> Maybe just formulas referring to hiden sheets or ranges.
>>
>> Tell us the name of the workbook and where you got it from(if downloaded, give
>> us a URL)
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Thu, 19 Jan 2006 13:40:03 -0800, "Kitchen Tune Up - Mario" <Kitchen Tune Up -
>> Mario@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >Microsoft Office Excel 2003. I have been trying desperately to find the
>> >following info:
>> >
>> >a) how the macros get data from the reference tables
>> >b) how to find these tables which seem to be hidden from users
>> >c) how to change some of the values used by the macros for calculations
>> >d) how to find out which macro uses what table for these calculations
>> >
>> >Can anyone help?
>>
>>

.

Relevant Pages

  • external reference error
    ... I have a spreadsheet that contains many sheets and there are references ... to particular ranges all over the place. ... So I want to simply change the reference to an external ...
    (microsoft.public.excel.programming)
  • Re: How to programatically control a 3D-sum?
    ... >Now I want to extend this to get the sum of all sheets from sheet"0" to ... >gives me #REFERENCE. ... You can't do this because of formula syntax. ... 3D references aren't ranges. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Update VB refs on insert cells
    ... This is a problem with hardcoded ranges. ... > cells to a worksheet which results in certain cells reference changing (eg ... > column B) my macros do not update the reference, ...
    (microsoft.public.excel.programming)
  • Re: Automating weeky copy / paste
    ... that your ranges contain more than one cell. ... hard for me to figure out how to place them in the "target" sheet. ... It won't be necessary to use any worksheet functions because we ... 'Loop through all sheets in workbook. ...
    (microsoft.public.excel.programming)
  • RE: Make code more concise
    ... your comments are appreciated so much - together with the proper ... creating proper references to the sheets and ranges you want. ... Refernce the sheet and the ranges. ...
    (microsoft.public.excel.programming)