Results 1 to 2 of 2

Thread: Using Selection.Address

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Using Selection.Address

    I highlight say cells B3:B8 - next I trap the cells by using "Selection.Address" - Now want to place a string (same string) in all the trapped cells - I tried

    Code:
    Selection.Address = Pcode
    Where Pcode is my string - but it does not work - any help would be appreciated - I am hoping I dont have to do a loop.

    Thanks
    Rasm
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    ahhh - got it
    Code:
    Selection.Value = Pcode
    xl2007 - Windows 7
    xl hates the 255 number

Similar Threads

  1. Replies: 2
    Last Post: 04-10-2013, 12:40 AM
  2. Replies: 4
    Last Post: 11-20-2012, 05:11 PM
  3. Replies: 3
    Last Post: 04-08-2012, 08:05 AM
  4. Mail Range or Selection using VBA
    By LalitPandey87 in forum Excel Help
    Replies: 1
    Last Post: 11-03-2011, 09:00 AM
  5. Replies: 6
    Last Post: 04-03-2011, 09:46 PM

Posting Permissions

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