Consulting

Results 1 to 4 of 4

Thread: Solved: Range Reference Quickie

  1. #1

    Solved: Range Reference Quickie

    Howdy,

    I am using a LastRow variable and I want to define a range as "F4:F&LastRow" but I am obviously not getting the syntax right. Can someone help me out??


  2. #2
    VBAX Master
    Joined
    Jul 2006
    Location
    Belgium
    Posts
    1,286
    Location
    [VBA]range("F4:F" & LastRow)[/VBA]

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Set rng = Range("F4").Resize(LastRow-3)

  4. #4
    Thanks all!

Posting Permissions

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