VBA Help

[william1990]

Hi, I am trying to copy the information in column B in one workbook and open another workbook and copy in a sheet in there, below is my code;

<code>

Columns("A").Select
Selection.Copy
Application.Workbooks.Open ("F:\SPREAD\Billy\excel\Excel VBA Test 2 No Help.xls")
Sheets("Sheet3").Activate
Columns("B").Select
Columns("B").PasteSpecial

<code>

can someone tell me why it is not working? runtime error appears at colums("B").select, it should be selecting that column on the Excel VBA Test 3 No Help workbook

 

[Stoneboysteve]

William,

Is the workbook really a test with instructions for no help? If so, do not use the code below.

For the people following the thread, this code snip should work.

Columns("A:A").Select
Selection.Copy
Application.Workbooks.Open ("F:\SPREAD\Billy\excel\Excel VBA Test 2 No Help.xls")
Sheets("Sheet3").Activate
Columns("B:B").Select
ActiveSheet.Paste

If it is a real test, shame.

Stoneboysteve