| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste problem
Why does this code work:
Sheets("CDPSD").Range("E1:E79").Copy Sheets("CDPTR").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True and this one not:? Sheets("CDPSD").Range("B1:B363").Copy Sheets("CDPTS").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True The 2nd code generates an error that says it can't paste becuase the destination is not the same size? Why does it work once and not later? How can I fix this? -- Thanks Shawn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste problem
Well, it appears to me, you are trying to transpose more than 256 columns
into a spreadsheet that can only handle 256 columns (until Excel 12.) -- Kevin Vaughn "Shawn" wrote: Why does this code work: Sheets("CDPSD").Range("E1:E79").Copy Sheets("CDPTR").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True and this one not:? Sheets("CDPSD").Range("B1:B363").Copy Sheets("CDPTS").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True The 2nd code generates an error that says it can't paste becuase the destination is not the same size? Why does it work once and not later? How can I fix this? -- Thanks Shawn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste problem
r/transpose more/transpose to more
The below should read transpose to more than 256 columns, not transpose more than 256 columns (but you knew what I meant, didn't you?) -- Kevin Vaughn "Kevin Vaughn" wrote: Well, it appears to me, you are trying to transpose more than 256 columns into a spreadsheet that can only handle 256 columns (until Excel 12.) -- Kevin Vaughn "Shawn" wrote: Why does this code work: Sheets("CDPSD").Range("E1:E79").Copy Sheets("CDPTR").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True and this one not:? Sheets("CDPSD").Range("B1:B363").Copy Sheets("CDPTS").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True The 2nd code generates an error that says it can't paste becuase the destination is not the same size? Why does it work once and not later? How can I fix this? -- Thanks Shawn |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste problem
So I was. I didn't need that many cells anyway so this was an easy fix.
Thanks for the pointer. Sometimes when you have worked on something all day, you just can't see the simple stuff. -- Thanks Shawn "Kevin Vaughn" wrote: Well, it appears to me, you are trying to transpose more than 256 columns into a spreadsheet that can only handle 256 columns (until Excel 12.) -- Kevin Vaughn "Shawn" wrote: Why does this code work: Sheets("CDPSD").Range("E1:E79").Copy Sheets("CDPTR").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True and this one not:? Sheets("CDPSD").Range("B1:B363").Copy Sheets("CDPTS").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True The 2nd code generates an error that says it can't paste becuase the destination is not the same size? Why does it work once and not later? How can I fix this? -- Thanks Shawn |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
paste problem
You're welcome. I just happened to notice it while reading your message.
Glad it helped. -- Kevin Vaughn "Shawn" wrote: So I was. I didn't need that many cells anyway so this was an easy fix. Thanks for the pointer. Sometimes when you have worked on something all day, you just can't see the simple stuff. -- Thanks Shawn "Kevin Vaughn" wrote: Well, it appears to me, you are trying to transpose more than 256 columns into a spreadsheet that can only handle 256 columns (until Excel 12.) -- Kevin Vaughn "Shawn" wrote: Why does this code work: Sheets("CDPSD").Range("E1:E79").Copy Sheets("CDPTR").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True and this one not:? Sheets("CDPSD").Range("B1:B363").Copy Sheets("CDPTS").Range("A2").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True The 2nd code generates an error that says it can't paste becuase the destination is not the same size? Why does it work once and not later? How can I fix this? -- Thanks Shawn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cut-and-paste problem | Excel Discussion (Misc queries) | |||
| Paste Problem Between Ex 97 vs 2k | Excel Discussion (Misc queries) | |||
| Paste Problem | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| CUT & PASTE PROBLEM | Excel Discussion (Misc queries) | |||
Hybrid Mode
