Convert existing worksheet to VBA code in order recreate the the identical worksheet

**kkruze** · 07-23-2016, 06:13 PM

I have a workbook with worksheets that include hundreds of rows and dozens of columns, fully formatted with borders, colors, formulas etc. The sheet contains both static areas and areas where users input information. What I want to know is there a way to take a sheet and copy (for lack of a better term) the underlying code or to put it another way have a spreadsheet be converted in to code that would replicate that same sheet(S).

I am not asking how to copy and paste a work sheet via vba. Nor do I want to have to record macros as a recreate a sheet, or starting coding from scratch.

Rather want to have the actual code that would result in the exact sheet being recreated once the code is run. Much appreciated

**FDibbins** · 07-23-2016, 11:50 PM

Hi, welcome to the forum

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.mrexcel.com/forum/excel-q...worksheet.html

Convert existing worksheet to VBA code in order recreate the the identical worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Convert existing worksheet to VBA code in order recreate the the identical worksheet

Re: Convert existing worksheet to VBA code in order recreate the the identical worksheet

Thread Information

Users Browsing this Thread

Similar Threads

Code to insert fields onto existing worksheet

VBA code to merge several identical worksheet tabs in to one 'total' master tab

[SOLVED] VBA code to save current worksheet as temporary PDF file and then add to my existing code

Adding cell zoom code to already existing code in single worksheet

[SOLVED] Excel 2003, Convert EXISTING Worksheet Data to XML?

[SOLVED] How do I convert an existing MS Excel worksheet tracking a simple.

[SOLVED] How do I convert an existing MS Excel worksheet tracking a simple.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions