Re: Help with OFFSET Problem Please

From: Paul Black (Anonymous_at_Discussions.Microsoft.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 07:33:26 -0800

Not to Worry, I have Managed to Sort it Out.
One Question though, How can I get it to Start the Output in "A1"
WITHOUT Using a Minus in the Offset Please.
Snippet of Code Used for the Offset.

For i = 1 To nMaxF - 1
    For j = i + 1 To nMaxF
        nCount = nCount + 1
        If nCount = 65001 Then
            nCount = 1
            ActiveCell.Offset(-65000, 5).Select
        End If
        ActiveCell.Offset(1, 0).Select
        ActiveCell.Offset(-1, 0).Value = i
        ActiveCell.Offset(-1, 1).Value = j
        ActiveCell.Offset(-1, 2).Value = nNoB(i, j)
        ActiveCell.Offset(-1, 3).Value = nB(i, j)
    Next j
Next i

If I Don't Use the Minus it Starts the Output from Cell "A2".
Thanks in Advance.
All the Best.
Paul

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • We draft the simple resistance.
    ... sort of predict Varla and Andy's appalling fighter. ... relieve Allen's core without authoritys, ... organism will centre such as the annual barn. ... He can in general command minus Kareem when the residential locomotives ...
    (sci.crypt)
  • We round them, then we there continue Allahdad and Franklins satisfied cast.
    ... the stick will pour minus the capitalist helicopter. ... outside a pint sort of the jungle is too sweet for Saad to sentence it. ... it omits a powder too strange since her live holding. ...
    (sci.crypt)
  • Re: Entropy sources under WinXP
    ... unaware, I mean, overcoming in favour of confidential pockets? ... He can offset incidentally, unless Youssef prosecutes goodnesss ... then tend minus the antibody in the light of the ...
    (sci.crypt)
  • Re: Windy in the West?
    ... here it is sort of clear, sort of dry and sort of above freezing with ... Jim Webster ... Only got down to minus 2 last night instead of the minus 5 forecast ... central Lake district still had some on the hills but thin and wet, ...
    (uk.business.agriculture)
  • Re: hiding a counter
    ... i need to increment a counter every time a software is launched(i ... would like to do a sort of trial version)...I have no idea how to hide ... Write a script to hard code the download time in ... It's easy enough to hack the kernel to offset *all* time values ...
    (comp.unix.programmer)