Copy And Paste Range on diffrenct sheet Selection problem Solved by : sixthsense

[HaroonSid]

hello evryone
i m using this code to select range and display in textbox1
select ragne = (c10:c15)
textbox1.value = (10:15)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myRange As Range
 Set myRange = Selection
 SID_EXTRA.TextBox1.Value = Target.EntireRow.Address(0, 0)
End Sub

But if i copy range = (c10:c15)
and paste on other sheet = (c10:c15)
then
textbox1 show only
textbox1.value = 10

i need result if i copy and paste a ragne
textbox1.value = 10:15


thanx

[:) Sixthsense :)]

Try it in this way....

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

With Selection
    SID_EXTRA.TextBox1.Value = .Row & ":" & .Rows.Count + .Row - 1
End With

End Sub

[HaroonSid]

not working

[HaroonSid]

Sorry Sixthsense

i was using wrong method

ur code is working fine

thanx a lot

u deserve +1