Results 1 to 2 of 2

Thread: [RESOLVED] Selecting nonAdjacent Cells?

Threaded View

  1. Nov 17th, 2005, 09:46 PM #1
    davidd31415
    davidd31415 is offline

    Thread Starter
    New Member
    Join Date
    Nov 2005
    Posts
    13

    Resolved [RESOLVED] Selecting nonAdjacent Cells?

    I see from the macro recorder that nonadjacent cells can be selected simultaneously like this:

    Range("G17,J34,N19").Select

    How can I do this using integers? Range(cells(x,y),cells(i,j)).Select selects an entire region (correct my vocab if incorrect please) and Range(cells(x,y),cells(i,j),cells(a,b)).Select produces a syntax error...

    Thanks
    Last edited by davidd31415; Nov 22nd, 2005 at 09:33 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width