Splitting a sheet into different sheets but keeping the same format as the origional one

**boomboomblock** · 07-01-2013, 10:36 AM

This piece of code splits my original sheet into sections. I want to keep the same format as the original sheet has, this is to keep the border lines, the title text fo the table and the cells with no gridlines in it. See attatcehd file for the formatting.

Formula:

Please Login or Register  to view this content.

**Norie** · 07-01-2013, 10:37 AM

Could you upload a sample workbook rather than a Word document with a picture?

**AB33** · 07-01-2013, 10:59 AM

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

**boomboomblock** · 07-01-2013, 11:30 AM

I was just about to upload a sample Norie, but thanks anyway.

**boomboomblock** · 07-01-2013, 11:36 AM

Here is my sample sheet attatched anyway

**Norie** · 07-01-2013, 11:45 AM

To start change this, which actually errors anyway,

Please Login or Register  to view this content.

to this.

Please Login or Register  to view this content.

For the title and headers change this,

Please Login or Register  to view this content.

to this.

Please Login or Register  to view this content.

**AB33** · 07-01-2013, 11:47 AM

The code works as per post #3

**boomboomblock** · 07-02-2013, 04:38 AM

I have played about with the code you have provided Norie and it brings most of the formatting over but doesn't return any values from my table, it is just a blank spreadsheet

**Norie** · 07-02-2013, 05:14 AM

Strange.

I took the original code and made all the adjustments I suggested and it worked fine.

The only part of the formatting that wasn't brought over was removing the borders in the cells around the table.

That could have been easily fixed by slightly adjusting the copied range and destination range.

**boomboomblock** · 07-02-2013, 05:18 AM

I was thinking the same for the borders. This code takes quite a while to process and returns blank sheets when I run it. It must just be my particular file that is causing this.

**Norie** · 07-02-2013, 05:36 AM

Does the original code work on the 'real' file?

**boomboomblock** · 07-02-2013, 06:56 AM

Sorry Norie I posted earlier but it didn't seem to go through. The code works for the real file and I have commented out the

Formula:

Please Login or Register  to view this content.

part to check for any bugs. It is running a bit slower than before but that is expected as it has to put grid lines in.

**boomboomblock** · 07-02-2013, 07:11 AM

The code seems to be printing blank sheets after a certain table is printed out with only two rows in the table, the other tables before this one are all around 20+ rows in the table

**Norie** · 07-02-2013, 07:52 AM

I don't think either of those problems are a result of the changes in the code.

Splitting a sheet into different sheets but keeping the same format as the origional one

LinkBack

Thread Tools

Rate This Thread

Display

Splitting a sheet into different sheets but keeping the same format as the origional one

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Re: Splitting a sheet into different sheets but keeping the same format as the origional o

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions