Results 1 to 4 of 4

Cell selection

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-24-2005
    Posts
    154

    Cell selection

    If I want to select a range of cells using
     Range("A3","A22").Select
    it works OK.
    How do I achieve the same result using
    Cells(3,1,22,1).Select
    the 3 & 22 being the range of rows and the 1 being column A.
    I cant get it to work at all.
    Have also tried
    Cells(3,1:22,1).Select
    but no joy.
    Thanx in advance
    Pete
    Last edited by VBA Noob; 04-11-2007 at 01:08 PM.

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