LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 28th 04, 10:47 PM posted to microsoft.public.excel.programming
AJ AJ is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 99
Default Sheet Formatting

Hi All,

I am trying to print a report on Excel sheet based on the formatting of
Active report. I have designed a template where the macro reads the xls data
and puts the values on the template where ever it belongs.

Now the question is, When I initialize the top and left properties for all
the labels and check boxes, it is placed nicely on the first page but if my
data needs a page break, I add some value to the top property for all the
check boxes so that it is placed properly on the next page. This works
perfectly fine with a set of data with fixed number of rows but it completely
ruins when I use another dataset where there are less rows.

Basically I need to tell my macro to set the fixed top property for all
labels and check boxes even if there are less rows in the xls data file. This
solve the problem, please help................


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting from one sheet to another seasteel Excel Worksheet Functions 1 May 14th 09 08:17 PM
Is there a shortcut for applying sheet formatting to another sheet M Kan Excel Discussion (Misc queries) 3 July 17th 08 08:33 PM
Sheet formatting after pivoting CG Excel Discussion (Misc queries) 0 May 17th 07 07:48 PM
Is there a way to carry formatting to a different sheet? ZBC2 Excel Discussion (Misc queries) 1 January 29th 06 11:23 AM
formatting in a protected sheet No Name Excel Programming 4 August 31st 04 11:10 PM

All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017