This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Excel Macro help

Question
0

Sign in to vote

I have a macro enabled workbook. I have a macro button to copy the sheet I'm on and create a new one.

When it copies over to the new sheet, it cuts off the bottom entry from each drop down menu.

Here is the macro below:

Sub NewTab()
ActiveWorkbook.Sheets("Client Template").Copy _
after:=ActiveWorkbook.Sheets("Client Template")
End Sub

Any help would be greatly appreciated.

Apparently not allowed to post images. :(

Wednesday, October 9, 2013 3:28 PM

Answers

0

Sign in to vote
Hi,

I tested the macro and it worked fine. Please refer to the following picture:

It seems that you may upload the picture after you had posted more than 5 threads.

If I misunderstanding something, please let me know.

Regards,

George Zhao
TechNet Community Support

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.
- Marked as answer by George123345 Monday, October 21, 2013 1:53 AM
Thursday, October 10, 2013 3:06 AM

All replies

0

Sign in to vote
Hi,

I tested the macro and it worked fine. Please refer to the following picture:

It seems that you may upload the picture after you had posted more than 5 threads.

If I misunderstanding something, please let me know.

Regards,

George Zhao
TechNet Community Support

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.
- Marked as answer by George123345 Monday, October 21, 2013 1:53 AM
Thursday, October 10, 2013 3:06 AM
0

Sign in to vote

Issue resolved. For some reason the copy macro was cutting off the last entry in each drop down menu we had.

We fixed this by going to the datasource, shifting all cells down one, then copying them back up. For some reason this worked and the last cell in each drop down is now properly being copied over.

Tuesday, October 15, 2013 2:23 PM