-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
leftfooter
-
C
Using Right(cellsxxxxxx) in LeftHeader
I've spent way too much time trying to figure this out and need some help. Trying to force my header to read the RIGHT 7 characters from cell I1 ActiveSheet.PageSetup.LeftHeader = _ Format(Worksheets("SHEET 1").Right(Cells(1, 9), 7).Value)- chefdt
- Thread
- Replies: 3
- Forum: Excel Questions
-
M
"New line" in footer with pagesetupfooter
Hello, please I have a problem with adding more lines into footer using pagesetupfooter. Does onyone know what special character can I use for new line in footer text? ActiveSheet.PageSetup.LeftFooter='Text in First line'+'\N '+'Text In Second Line' But \N does not work. Any Ideas? Thanks a...- matko
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...