Basic syntax question regarding "COPY"

[kuants]

Hi I'm new to this forum and also a newbie with VBA.

So very simply I have a question about VBA syntax regarding "Copy".

The following line of codes actually works by managing to copy what is in my active sheet and pasting it in my worksheet in thisworkbook:

Please Login or Register  to view this content.

Why does the above line of codes works? But not the following two lines which gives me an error "object does not support the property or method" for my 2nd line? :

Please Login or Register  to view this content.

I've always thought a Destination Parameter is needed if you want to copy and paste in a single line. Otherwise you would need one line for copy and another line for paste.


In case, you are wondering why I have an 'Activesheet' and a 'Thisworkbook'. I am actually trying to open a delimited file for pasting into my current workbook. The preceding line is to my above codes would be:

'Workbooks.OpenText Filename:=strFN, DataType:=xlDelimited, Tab:=True


Sorry if this is too rudimentary a question to ask. I'm just starting to pick up VBA.

[royUK]

Have you read the Forum Rules yet/ The thread title could be better & you haven't used Code Tags.