Being quite new at this as you can see I am not sure if I have the right forum or not but I am certainly looking for whatever assistance I can get. I have also posted this in VB Language as well, hoping that someone much brighter than I will take pity on me.
I am trying to get this code to work but I get the above noted error. I am trying to have the user in the workbook Inv_SKU_Build.xls ..press a command button which will open the workbook noted copy the contents of colums a,b and c and paste that in sheet 2 of the Inv_SKU_Build.xls workbook.
I get the error and the debugger has the Columns("A"C")Select highlighted
Hi and welcome to this forum. Unfortunately the VisualBasic forums here are dedicated to VB.NET and not VBA (or VB6) which appears to be what you are working with. However, there is a thread at the top of this forum with instructions for where you can find assistance with your question. Here's the link to it...
Good Luck! On first glance there is nothing wrong with the syntax of Columns("A:C").Select -- it definitely works on its own. Perhaps there is no workbook activated (i.e. your workbook.Activate call failed, perhaps the filename text argument is wrong?)