Printing Format after worksheet update

**suar** · 05-31-2012, 12:14 AM

Hi,

One of our accountants revised our DRR to insert 2 rows. After revision, one worksheet is not aligned every time it updates. As shown in screenshot, covers figure move down after update.

1st screenshot before update, 2nd screenshot after update (covers encircle in red). To simulate update you may press F2 (excel attached) on date cell (ex. May 28, 2012) and enter.

How to fix the formatting after update?

Thank you very much and more power to excelforum.com

-Suar

screenshot1.jpg screenshot2.jpg

**suar** · 05-31-2012, 07:57 AM

hi gurus..any assistance will be greatly appreciated..

**suar** · 05-31-2012, 07:36 PM

Hi, could anyone point me where to get help about my issue? maybe i'm in the wrong forum. Thank you very much.

**martindwilson** · 05-31-2012, 07:39 PM

no one is going to open that link. post a workbook with the code in it.

**suar** · 06-01-2012, 09:09 PM

Hi Martindwilson,

Thank you very much for the information as I'm very new in posting programming issue in forums.

I revise above post and attached excel.

Thank you very much.

-Suar

**martindwilson** · 06-02-2012, 07:11 AM

first ask your accountant what he added, then tell us where this code is

**suar** · 06-03-2012, 01:31 AM

She added wedding and beach BBQ rows in "data entry" worksheet then add wedding and beach BBQ columns in other 2 worksheets.

**dangelor** · 06-03-2012, 08:23 AM

The code attached to the Data Entry worksheet, (see below), relies on specific cell locations in the Daily worksheet. By adding those extra columns in the Daily worksheet, you moved the cells and 'broke' the code.

HTH,
Rich

Please Login or Register  to view this content.

**Marcol** · 06-03-2012, 09:49 AM

WARNING: Don't open the attachment in Post #1 unless you want to reset your Excel defaults after you've helped

Also ...

Your Sub UpdateChanges calls Sheets("Daily Report")

There is no such sheet in your workbook.
In the immediate pane

Please Login or Register  to view this content.

returns 3

Please Login or Register  to view this content.

returns "Data Entry"

Please Login or Register  to view this content.

returns "Daily"

Please Login or Register  to view this content.

returns "USE"

**suar** · 06-04-2012, 01:28 AM

Thank you very much to all your reply.

I remove other worksheets that doesn't have relation to the issue at hand. The size of the excel is so huge if I will not remove other worksheets.

I am hoping there will be a fixed or a work around so that the values will be position on correct cells.

Thank you very much and more power to excelforum.com.