Subscript out of range

[Biplab1985]

Hello,

Need help to fix a code. I am trying to copy all the information from DFG, Geo tab of thisworkbook to Created workbook("DFG_" $environ("username"), doing so I am getting and subscript out of range error. I have underlined the code statement which seems to be incorrect.

Please Login or Register  to view this content.

[AB33]

It means the sheet names do not exist, you need to check the spelling, including spaces.

[Biplab1985]

Sheet exist. I checked again looks fine to me.

[AB33]

If you are getting an error on this line

With Workbooks("DFG").Sheets("Geo").Range("A1")

It could be the Workbooks("DFG"). does not exist or it is not the active book( If you open two books at the same time), or the sheet name "Geo"with in sheet Workbooks("DFG") does not exist.

[Norie]

Replace Workbooks("DFG") with newbook.

Please Login or Register  to view this content.

[Biplab1985]

Thanks! It worked using Newbook .

Now I am getting Application Defined or object error in

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Biplab1985]

Thanks for all your help Norie! It worked like a charm.

One more help, I am trying to attach the Exception_Template to "Exception" sheet of newfile. Getting an application or Object defined error. Am I going wrong somewhere.

Please Login or Register  to view this content.

[Biplab1985]

Any suggestions?

[Norie]

I'm not sure what you are trying to do.

This line of code will create a copy of the sheet 'Exception_Template' in its own, new, workbook.

Please Login or Register  to view this content.

[Biplab1985]

What i am trying to achieve here copy the exception_template worksheet and paste it in the New worksheet of workbook "Newbook" where other 2 worksheets is already added - DFG & Geo.

[Norie]

If you want to copy a worksheet from one workbook to another specify the destination after Copy.

Please Login or Register  to view this content.

If you want to copy the data from a sheet in one workbook to a sheet in another try this.

Please Login or Register  to view this content.

If you want to hide the sheet you've copied/copied from do it after you've done the copy.

[Biplab1985]

Thanks Again Norie, it worked perfectly!