#1
|
|||
|
|||
Transferring Tables acting strangely
So I found an example online and modified it to use it as best I could. For the most part it works fine, but I randomly get bits of data being transferred over into random cells at any time without the button even being clicked. Is there a better way to go about doing this that won't produce those stray transfers?
Code:
Sub Transpose1_Click() Worksheets("Authorization Codes").Range("B12:P111").Copy Worksheets("1").Range("B5").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, SkipBlanks:=True Application.CutCopyMode = False Worksheets("Authorization Codes").Range("B12:P111").ClearContents Worksheets("Authorization Codes").Cells.ClearComments Worksheets("Authorization Codes").Range("B157") = 1 Worksheets("Authorization Codes").Range("C157") = 1 End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tables Acting Up | CrossReach | Word Tables | 10 | 05-30-2016 03:22 AM |
Word acting squirrely again. | jmdraft | Word | 10 | 11-18-2014 07:21 AM |
Mouse working strangely | tonyvella | Office | 0 | 10-11-2012 11:41 AM |
Outlook 2003 behaving strangely. | Fearmor | Outlook | 0 | 06-02-2012 11:57 AM |
Outlook 2003 acting up | TimberJon | Outlook | 0 | 02-08-2010 10:24 AM |