Results 1 to 3 of 3

select range in another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2008
    Posts
    70

    select range in another worksheet

    Dear All,

    I am using the below code which works perfectly in same sheet. But instead of range a1 and b1 in the same sheet (bold one), i want to use range a1 and b1 of sheet2. Range "Nazim" is named range in sheet1. And this code will be put in sheet1.


    Private Sub Worksheet_selectionChange(ByVal Target As Range)
    
    If Not Intersect(Target, Range("nazim")) Is Nothing Then
    Range("a1").Value = Target.Value
    Range("b1").Value = Target.Offset(, 1).Value
    End If
    
    End Sub
    Thks

    Nazim
    Last edited by nazimscr; 10-23-2009 at 06:44 AM.

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