• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to adjust print title in macro

S

sdsurzh

Member
Hi,


I have a data where the header may move from 35 to 45 (after running the report may be first time it will be in 35 and second time will come down to 45 )how do i can declare the title in code.

By default the recorded macro code taken it as.PrintTitleRows = "$35:$40". Now i want to find out the header and depends upon the printtilerows should adjust. Header Name = Income


Thanks,

Suresh Kumar S
 
Can you better describe how to determine where the header row is? Are we looking for a specific word, is it the first cell with text in a specific column, is it...?
 
Luke,


It would come in row # 35 to 45 depends upon the output report sometime it would come in 35th row or 40th row. The Header name would be starting with Income.


Thanks,

Suresh Kumar S
 
Does this help you out? Lets you know where the header row is:

[pre]
Code: 
Dim MyRow As Long

MyRow = Range("A:A").Find("Income", Range("A1")).Row
MsgBox "Header found in row: " & MyRow
[/pre]
 
Ok...so do you need more help, or did you solve it? Now that you know the header row, should be able to just plug that into the
Code: 
PrintTitleRows
object. Or is there more to the story?
 
Klujianrugs Brings an Amazing Collection of Chicago Rugs at Unbeatable Price Tags </br>January 20, 2012: klujianrugs, a pioneer in carpet and rugs since 1938, brings an authentic collection of amazingly woven Chicago rugs in different styles, designs, colors and sizes. Located in Rogers Park on Devon Avenue (same location for last more than 75 years), Mathew Klujian & Sons—the Mother Company of Klujianrugs has a finest collection of rugs and carpets from 80 to 110 years old that are collected through various sources from all parts of the world. Klujian & Sons is also a one stop shop for in-plant cleaning, repairing, restoration and sales.

Located on the same location for last almost 75 years (since 1938), Klujian and Sons has come up with the finest collection of Chicago carpets that are from 80 to 110 years old through its online wing Klujianrugs. However, On-site store in Rogers Park on Devon Avenue is also a centre of attraction in it for offering those Chicago carpets and rugs that you will hardly find anywhere. Some of the finest Chicago carpets available at Klujianrugs are Shag carpet, Sisal Carpet, Berber Carpet, Pattern Carpet, Frieze Carpet, Saxony carpet Cheap Jordan 11, outdoor carpet and commercial carpet He Got Game 13s.

In addition to this, these carpets are hand-woven jewels that are from cottage-made jewels woven in small villages to exclusive gems entangled in established weaving centers in foremost cities. To elaborately describe the Chicago rugs, one of the senior executives of Klujianrugs remarks, “We have grown and modernized throughout the years and we are proud to say that there are many things remaining the same as the day that Mathew Klujian Sr. opened the store in the year of 1938”. Apart from offering unique collection of Chicago carpets, the leading company is also a one stop shop for cleaning, repairing, restoration and sales of different types of rugs Jordan 13 Cool Grey Fusion Pink. Klujianrugs has also a cleaning center in ChicagoLand area. In this way, one is assured that their carpets don’t send somewhere else to have them cleaned. Even, other carpet retailers and cleaners also send Chicago carpet to this leading store.

Located in Rogers Park on Devon Avenue (same location for last more than 75 years), Mathew Klujian & Sons, Mathew Klujian and Sons is a pioneer company in the field of rugs and carpets since 1938. The leading carpet and rugs company has its own cleaning center in Chicagoland area.

Chicago carpet</body></html>
 
You must log in or register to reply here.
Back
Top