here is my problem while the command is executing "copy paste" it flashes the square a few times and then it stops. and after all the values blink and don't stop blinking in the edit field next to the function icon.
here is the command.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Select Case Range("J11")
Case "duo1"
Range("Q11:Q15").Select
Selection.Copy
Range("K11").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Select
End Sub
Hi, K-Ching,
please be informed to use code-tags when presenting procedures here on ExcelForum. Please add them according to Forum Rule #3. TIA.
Deactivate the procedure in ThisWorkbook and add the following procedure behind Sheet1:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
thank you works fine and now i wold like to know how to get the range from another sheet
thank you i figured it out
Select Case Target
Case "duo1"
Application.EnableEvents = False
Range("K11:K15").Value = Sheets("1").Range("A2:A6").Value
Application.EnableEvents = True
Hi, K-Ching,
glad you could figure it out by yourself. But I would like to remember you to take some time to read the Forum rules and apply code-tags whereever you have posted a procedure. Code-tags make code easier to read and copy.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks