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? |
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 |