Hellp - Subscript Out of range Error

[Biplab1985]

Can some helpt to know what is wrong in the below code -

Please Login or Register  to view this content.

[nigelbloomy]

It works fine for me when I run it like this:

Please Login or Register  to view this content.

It creates a new workbook out of the sheet. If you are getting that error I would check the name you have in there for your sheet.

[karedog]

It means that there is no sheet with name : "ALL Brand Buyers Request form" exist in ActiveWorkbook.

[JoeFoot]

wrong sheet name. double check the spelling.

[GC Excel]

Does the Sheet "ALL Brand Buyers Request form" exists in your workbook?
Make sure the is no extra or trailing spaces.

[Biplab1985]

I am still getting the error-

Here is the entire code - 2 command button. first - to create the sheet and second - save the sheet to a location. Please check the code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Biplab1985]

Any Help??

[nigelbloomy]

The only thing I can think of is that when you click that second button, the activeworkbook, which is probably the one with the button that you just clicked, doesn't have a sheet called "ALL Brand Buyers Request form".

[Biplab1985]

SHeet name is correct i checked it. There is some oroblem with the activesheet when i am using 2 command buttons. I achieve what i am seeking when i use both codes in one command button.