Subscript out of range

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.

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

Sheet exist. I checked again looks fine to me.

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.

Thanks! It worked using Newbook .

Now I am getting Application Defined or object error in

Please Login or Register  to view this content.

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.

Any suggestions?

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.

Thanks Again Norie, it worked perfectly!