Advertisement

1 - 10 of 157 containing alltags:("offset") (0 seconds)
I want to reference a lib in access that the user may or may not have.  Presently if the user does not have the lib then the code will crash. An example would be, the code references the Word 97 ob...
Zones: MS AccessDate Answered: 03/17/2002 Grade: A Views: 0
When loging onto certain websites such as www.used-machines.co.uk  my explorer shows the following error and has to be restarted AppName:iexplorer.exe  AppVer:6.0.2600.0 ModName:msjava.dll     ...
Zones: Windows 98Date Answered: 09/07/2002 Grade: A Views: 0
The code below looks for a blank cell under column K from K9 downwards and when it finds it formats the cell as 0.0 and makes the cell value the answer to the offset of  -1 / 08 * 100. Can someo...
Zones: MS ExcelDate Answered: 11/15/2004 Grade: A Views: 0
i have set some names in my worksheet using OFFSET to generate dynamic ranges. I also use function COUNTCONTIGROWS to generate dynamic ranges based on the last column with data on the range. wo...
Zones: MS ExcelDate Answered: 03/18/2006 Grade: A Views: 0
In two of my database-based spreadsheets, I have come accross a problem that I cannot solve. Namely, that formulas using the OFFSET function cease to work. The error checker displays the #value err...
Zones: MS ExcelDate Answered: 04/17/2006 Grade: A Views: 0
I have 2 tabs: PCO_LOG and Possible_Total_Revised_Contract. PCO_LOG Range =OFFSET(PCO_LOG!$A$1,0,0,COUNTA(PCO_LOG!$A$1:$A$300),14) Defined name="PCOLOG_Print_Area" Possible_Total_Revised_Co...
Zones: MS ExcelDate Answered: 05/04/2006 Grade: A Views: 0
Hi Would anyone have a good example on how to use =Offset(). Greg
Zones: MS ExcelDate Answered: 09/23/2006 Grade: A Views: 96
I am trying to name a dynamic range using offset.  I can successfully utilize the formula on one set of values.  However, if I replace the data in the worksheet with a different set of values, the ...
Zones: MS ExcelDate Answered: 12/21/2006 Grade: A Views: 0
I am trying to mark column B for all rows starting with 1's (1,11,21,31 etc) with the number 1. Here is the code I have so far; but it just adds 1 for all rows of column B.....offset does not seem ...
Zones: Visual Basic v1.0.5.x, Visual Basic, Microsoft Programmi...Date Answered: 04/18/2007 Grade: A Views: 133