About Us

Pistolade

No matter what I do I just cant get it to go to the right position. If it worked correctly the macro would copy cells A2:O33, copy them, activate sheet "Variables QS", Then select the next open cell in column B and paste the earlier selection.

That is it. and I just cant get it to work, I never had this issue before.

Heres the code im using:

Code:

Sub SavingTable()
'
' SavingTable Macro
'
'
    Range("A2:O33").Select
    Selection.Copy
    Sheets("Variables QS").Select
    Range("B1").End(xlDown).Offset(-1,0).Select
    ActiveSheet.Paste
    Sheets("Variables").Select
    Range("G1").Select
    Selection.Copy
    Sheets("VariablesQS").Select
    Range("A1").End(xlDown).Offset(-1,0).Select
    ActiveSheet.Paste
End Sub

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
End(xlDown)	Normek	Excel Programming	5	July 13th 09 10:46 AM
A1:B(xlDown)?	Simon[_2_]	Excel Programming	5	July 29th 08 10:23 AM
End(xldown) not always going to last cell?	Duncan[_5_]	Excel Programming	6	May 4th 06 10:30 AM
XlDown: Go to next blank row	tomwashere2	Excel Programming	2	August 16th 05 11:15 PM
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue.	jonH	Excel Programming	3	June 7th 04 09:13 PM

Menu

About Us