Basic VBA Question about Sheets, Ranges, Selection

[mvervair]

Ok, I've been trying to understand this but right now I'm stuck. This is the piece of code I've been trying to run to copy / paste

Sheets("job_tracking").Range("C1").Select

However, this does not work.

Instead I wind up using this:

Sheets("job_tracking").Select
    Range("C1").Select
    Selection.End(xlDown).Select
    Selection.Offset(1, 0).Select
    Selection.PasteSpecial

My confusion is coming from my (lack of) understanding about how objects work. I'm thinking I should be able to access the properties and methods of objects. So to access cells of a page I should be able to use Workbook.Worksheet.Range.Copy format, right? Obviously not, but this is where I'm coming from.

 

[Norie]

You should be abe to use Workbook.Worksheet.Range.Copy to copy cells and you should be able to do it without using Select/Selection.

What range do you want to cop and where do you want to copy it to?

 

[mvervair]

Thanks for responding Norie.

Here is the actual code below, it does work for copying. Shouldn't it also work the same way for the pastespecial method?

Sheets("data_valid").Range("J2").Copy
    Sheets("job_tracking").Select
    Range("C1").Select
    Selection.End(xlDown).Select
    Selection.Offset(1, 0).Select
    Selection.PasteSpecial _
    Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

 

[Norie]

How is it not working?

Does this work?

Sheets("data_valid").Range("J2").Copy
Sheets("job_tracking").Range("C1").End(xlDown).Offset(1).PasteSpecial _
    Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

 

[mvervair]

Works perfectly, I guess my understanding isn't too far off. Thank you!