Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to previous worksheet after code pastes in another worksheet?
Hi Guys,
Im teaching myself vba [or trying to!] so my code attempts may reek of amateur, but hell, we all started somewhere. I have 35 very similar worksheets that grab financial data from a web query. I only use one sheet at a time though. The active sheet then has to format a load of data and paste it into a mastersheet. What I need to do but can't grasp it is when I am in the active sheet and do a cut of the relevant data, then tell my code to select the 'Data Collection' worksheet and pastes it, I need to go back to the previous sheet to clear some leftover data ready for the next time this particular collection sheet is used. I tried to set the activesheet name as a variable to refer back to it later but it simply stays in the 'Data Collection' worksheet instead of going back, or I generate a vba error. Any help would be appreciated. Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to previous worksheet after code pastes in another worksheet?
Ron
Do not select the Data Collection sheet. ActiveSheet.Range("A1:J10").Cut _ Destination:=Worksheets("Data Collection").Range("A1") Will leave you on the Activesheet. To cut and paste to next available blank row on Data Collection sheet ActiveSheet.Range("A1:J10").Cut _ Destination:=Worksheets("Data Collection").Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0) Gord Dibben Excel MVP On 04 Sep 2004 16:50:59 GMT, Ron wrote: Hi Guys, Im teaching myself vba [or trying to!] so my code attempts may reek of amateur, but hell, we all started somewhere. I have 35 very similar worksheets that grab financial data from a web query. I only use one sheet at a time though. The active sheet then has to format a load of data and paste it into a mastersheet. What I need to do but can't grasp it is when I am in the active sheet and do a cut of the relevant data, then tell my code to select the 'Data Collection' worksheet and pastes it, I need to go back to the previous sheet to clear some leftover data ready for the next time this particular collection sheet is used. I tried to set the activesheet name as a variable to refer back to it later but it simply stays in the 'Data Collection' worksheet instead of going back, or I generate a vba error. Any help would be appreciated. Ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to previous worksheet after code pastes in another worksheet?
Don and Gord,
Thanks guys for answering so quick. I was trying to copy from the source sheet and go to the destination sheet and then back to the source sheet. The examples you have both gave will help me no end in the future, thankyou both. Ron |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to previous worksheet after code pastes in another worksheet?
As we said, you do not need to go back and forth. Just copy or cut to the
destination sheet. -- Don Guillett SalesAid Software "Ron" wrote in message 10.200... Don and Gord, Thanks guys for answering so quick. I was trying to copy from the source sheet and go to the destination sheet and then back to the source sheet. The examples you have both gave will help me no end in the future, thankyou both. Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference cell from previous worksheet without "naming" worksheet | Excel Worksheet Functions | |||
Returning To Previous Worksheet - Help with sebastienm's code | Excel Discussion (Misc queries) | |||
I need to return the name of a worksheet in another worksheet cell? | Excel Worksheet Functions | |||
How do I return to a previous worksheet in Excel? | Excel Discussion (Misc queries) | |||
Macro to return to previous worksheet | Excel Programming |