Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clear cells with count... (2000 sp 1)

    inested 3 how to assign to K the value intercepted with

    CONTA = Sheets("RATE").Cells(65536, 11).End(xlUp).Row + 1

    similar K & CONTA:Z5000

    Sub CANCELLA_LINEE()

    CONTA = Sheets("RATE").Cells(65536, 11).End(xlUp).Row + 1
    Sheets("RATE").Range("K3:Z5000").ClearContents

    End Sub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Clear cells with count... (2000 sp 1)

    <code>Sheets("RATE").Range("K" & CONTA & ":Z5000").ClearContents</code>

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear cells with count... (2000 sp 1)

    GOOD! And if the count value is in A2?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Clear cells with count... (2000 sp 1)

    You should be able to figure that out yourself!

    <code>Sheets("RATE").Range("K" & Range("A2") & ":Z5000").ClearContents</code>

Posting Permissions

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