Dear All, I want to know is it possible to set automatic page numbering in excel (in different sheets) as in Word and also specify the page number of the first page. When we select all the sheets at a time and set page numbers in header or footer it works. But I cannot specify a different page number for first page. Moroever it doesn't work when all sheets are not selected. Please help
Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 (0361-2603895,9435019908 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ram kumar.m Sent: Friday, April 17, 2009 9:06 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Function to Find the word is in Upper case or lower case or mixed.... Thanks paul.. As i too didn't get any idea than which you have specified belwow, i too used the macro function to check..... Anyways thanks once again paul:) Regards, Ram. On Mon, Apr 13, 2009 at 6:36 AM, Paul Schreiner <schreiner_p...@att.net> wrote: Well... to answer your EXACT question, there isn't a simple function to do that. (that I know of!) However: If you're wanting a FORMULA, then you can use: =IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed")) If you're wanting a function: I inserted this function into a Module: Public Function Check_Case(Str As String) If (Str = UCase(Str)) Then Check_Case = "Upper" ElseIf (Str = LCase(Str)) Then Check_Case = "Lower" Else Check_Case = "Mixed" End If End Function hope this helps... Paul _____ From: ram kumar.m <ramsk0...@gmail.com> To: excel-macros@googlegroups.com Sent: Monday, April 13, 2009 6:12:03 AM Subject: $$Excel-Macros$$ Function to Find the word is in Upper case or lower case or mixed.... Hi, Is there any function to find whether the word entered in a cell is fully in upper case or lower case or in mixed case? Can any one please help me as soon as possible....... -- Thanks and Regard ramkumar.m HAVE A NICE DAY FRNDS:) -- Thanks and Regard ramkumar.m HAVE A NICE DAY FRNDS:) --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<inline: image001.jpg>>
