+ Reply to Thread
Results 1 to 3 of 3

How to use range quotes. Having trouble understanding Range syntax

  1. #1
    Registered User
    Join Date
    05-29-2010
    Location
    West
    MS-Off Ver
    Excel 2007
    Posts
    7

    How to use range quotes. Having trouble understanding Range syntax

    Below is my code. I just want to select the range from the activecell to the last cell used in the column. There may be blanks so I just want to go to the last cell used. FYI I use "t" in front of my variables to eliminate any possible conflict between my variable name and the possible chance that excel has one with the same name.

    I cannot understand how when why to use the quotes for the Range. I am sure there are other problems with the code. Any help appreciated.

    Please Login or Register  to view this content.
    Last edited by gpxfiles77; 06-23-2010 at 07:21 PM. Reason: Notified that my post broke the forum rules

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: How to use range quotes. Having trouble understanding Range syntax

    Hi gpxfiles77
    Maybe something like this?
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    05-29-2010
    Location
    West
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to use range quotes. Having trouble understanding Range syntax

    Thank you for your post. I am a noob at this and this is my very first VBA program. It took me hours to write and understand it. Any comments on technique or structure or anything is appreciated. It doesnt do much, just selects the cells from the active cell down to the last used cell in that same column.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1