| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with complicated(?) Range
I am trying to cut information from a known set of columns (A:Q) with a
variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
Try to add this line to your code:
Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
VBA doesn't like the : in the statement you gave me. Typo or any other ideas?
Thanks. "Tim" wrote: Try to add this line to your code: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
Sheets("Deleted").Range("A" & xLastRow & ":Q" & xLastRow).ClearContents
Tim wrote: Try to add this line to your code: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
This seems to have gotten a little off what I am trying to do. But I have
used what you have given me to make this line: Sheets("Deleted").Rows(xLastRow) = Sheets("Data").Range("A" & iLastRow & ":Q" & iLastRow).Value Which looks like what I want it to do except it doesn't seem to do anything. No information is copied. Can you Please HELP? Thanks alot "Dave Peterson" wrote: Sheets("Deleted").Range("A" & xLastRow & ":Q" & xLastRow).ClearContents Tim wrote: Try to add this line to your code: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
Try to change your code to this:
Sheets("Data").Rows(xLastRow) = Sheets("Deleted").Range("A" & iLastRow & ":Q" & iLastRow).Value Tim "Haxer" wrote: This seems to have gotten a little off what I am trying to do. But I have used what you have given me to make this line: Sheets("Deleted").Rows(xLastRow) = Sheets("Data").Range("A" & iLastRow & ":Q" & iLastRow).Value Which looks like what I want it to do except it doesn't seem to do anything. No information is copied. Can you Please HELP? Thanks alot "Dave Peterson" wrote: Sheets("Deleted").Range("A" & xLastRow & ":Q" & xLastRow).ClearContents Tim wrote: Try to add this line to your code: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
Sorry, it still does the same thing, nothing! Thanks for the help though. I'm
pulling my hair out here! Anymore ideas feel free to pass them my way! Thanks again "Tim" wrote: Try to change your code to this: Sheets("Data").Rows(xLastRow) = Sheets("Deleted").Range("A" & iLastRow & ":Q" & iLastRow).Value Tim "Haxer" wrote: This seems to have gotten a little off what I am trying to do. But I have used what you have given me to make this line: Sheets("Deleted").Rows(xLastRow) = Sheets("Data").Range("A" & iLastRow & ":Q" & iLastRow).Value Which looks like what I want it to do except it doesn't seem to do anything. No information is copied. Can you Please HELP? Thanks alot "Dave Peterson" wrote: Sheets("Deleted").Range("A" & xLastRow & ":Q" & xLastRow).ClearContents Tim wrote: Try to add this line to your code: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with complicated(?) Range
One more try:
Sheets("Data").Range("A" & iLastRow & ":Q" & iLastRow).Value = Sheets("Deleted").Rows(xLastRow) Tim "Haxer" wrote: Sorry, it still does the same thing, nothing! Thanks for the help though. I'm pulling my hair out here! Anymore ideas feel free to pass them my way! Thanks again "Tim" wrote: Try to change your code to this: Sheets("Data").Rows(xLastRow) = Sheets("Deleted").Range("A" & iLastRow & ":Q" & iLastRow).Value Tim "Haxer" wrote: This seems to have gotten a little off what I am trying to do. But I have used what you have given me to make this line: Sheets("Deleted").Rows(xLastRow) = Sheets("Data").Range("A" & iLastRow & ":Q" & iLastRow).Value Which looks like what I want it to do except it doesn't seem to do anything. No information is copied. Can you Please HELP? Thanks alot "Dave Peterson" wrote: Sheets("Deleted").Range("A" & xLastRow & ":Q" & xLastRow).ClearContents Tim wrote: Try to add this line to your code: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow).ClearContents Tim "Haxer" wrote: I am trying to cut information from a known set of columns (A:Q) with a variable row and move them to a known set of columns (A:Q) with a variable row. I think it should look something like this: Sheets("Deleted").Range("A" & xLastRow&:"Q"&xLastRow)=Sheets("Data").Range("A" & i:"Q"&i) Actually what I have above is when I was trying to copy. I am no longer trying to copy but actually cut and paste. Any help please? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGE(with complicated range -blanks..) | Excel Worksheet Functions | |||
| Too Complicated For Me | Excel Discussion (Misc queries) | |||
| This is more complicated than it looks. | Excel Worksheet Functions | |||
| Something perhaps a little complicated | Excel Discussion (Misc queries) | |||
| Complicated | Excel Worksheet Functions | |||
Linear Mode
