Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi use this cod eto have a number of cells in column.

    dim cella as long
    dim ws4 as worksheet
    Set WS4 = ThisWorkbook.Worksheets("TEST")
    CELLA = WS4.Range("C" & Rows.Count).End(xlUp).Row

    When i open the workbook from a dir C:\ and start the code all work fine.
    But when i depoist in dir of http:\ and call it via link the code go in error 1004....method global...eccc

    why??????

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Probably the file opens in Internet Explorer. VBA code in Excel files does not work well when the file is opened in IE.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •