$$Excel-Macros$$ How to remove page 1

Hi Experts, Is there an option to remove the page no in background when a section in a sheet is viewed in Page Break Preview? Thanks in advance. Best, Sharad -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

$$Excel-Macros$$ Re: record a macro

Hello Akhilesh, Elaborate your exact requirement. Kishan Reddy, K On Oct 28, 5:10 pm, airen wrote: > Hi Experts, > Is there any way to record a macro between applications? > > Thanks > Akhilesh Airen -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Find a value in column A and make row above bold

TRy this Sam On Sat, Oct 29, 2011 at 4:30 AM, Hayhurst, Glenn A < glenn.a.hayhu...@lmco.com> wrote: > Hi. I am trying to find cells in Column A with a value of “0” and then > navigating up two rows and making that entire row bold. It all falls apart > after I try to use Offset. Where did I go w

Re: $$Excel-Macros$$ Convert amount to Million

Yes SAM I want to enable this macro for all excel sheets in shape of add in. Well .xlam is attached where I am created new 2nd module however your "Convert to Million" Macro is running fine in sheet but when I enter this macro into add in file this won't work. Aamir Shahzad On Sat, Oct 29, 2011 a

$$Excel-Macros$$ Find a value in column A and make row above bold

Hi. I am trying to find cells in Column A with a value of "0" and then navigating up two rows and making that entire row bold. It all falls apart after I try to use Offset. Where did I go wrong? Sub BOLDAboveZero() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR

$$Excel-Macros$$ Re: Advanced Filter

Akhilesh, =ISNA(MATCH($A5,Sheet1!$A:$A,0)) If A5 is *NOT* contains in Sheet1Col_A this will return TRUE, if contains FALSE. So Advanced Filter will look for each cell in the range & extract the record which is = TRUE. see the below link. Hope this help you more. http://www.contextures.com/xlad

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

Hello XLS S; Let me try to explain my best :) In sheet2 B1, used a formula to get all items in sheet1, which is =COUNTA(Source!A3:Z65536) B2, used too get total columns used, which is =COUNTA(Source!A2:Z2) Based on the attached, there are 3 columns & 300 rows. So, first 3 rows need the data

Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet

Don, I used your method, however, it is part of my requirement. Next will be spliting the data into 2 according to the location of the data. For example, 3MR3C14015 to be put in worksheet "MR", others put in "CY". 2011/10/29 dguillett1 > What you do NOT understand that is if you do it your w

Re: $$Excel-Macros$$ To send mail from excel.

There's a custom version here... I'm sure you can make the minor tweaks from here on http://www.excelfox.com/forum/showthread.php?142 Regards, Sam Mathai Chacko (GL) On Sat, Oct 29, 2011 at 3:38 AM, kurikkal padinjarappalla < padinjarappa...@gmail.com> wrote: > Dear Sam, > > Can u please m

Re: $$Excel-Macros$$ To send mail from excel.

Dear Sam, Can u please modify it from your side as i am zero in VBA. On Sat, Oct 29, 2011 at 12:49 AM, Sam Mathai Chacko wrote: > Kurikkal, > > This is meant to do what you require. I'm sure you can make modifications > to your code after looking at this.. > > > http://msdn.microsoft.com/en-us/l

Re: $$Excel-Macros$$ Convert amount to Million

Why do you want this in another add-in? Do you want the feature to be available in ALL the workbooks that you use? Also Aamir, a normal add-in does not have the require events to capture a change in the sheets in another workbook. To get it to run automatically, you'll need to call an application

Re: $$Excel-Macros$$ Convert amount to Million

how to call? is it not run automatically when enter 1M & enter? Aamir Shahzad On Sat, Oct 29, 2011 at 2:52 AM, Sam Mathai Chacko wrote: > The original code that I gave should have been written within a workbook. > But now that you are using an add-in, yes you can use it in a different > module,

Re: $$Excel-Macros$$ Number Formats in French

If you use ",00" in the format, it will always show as ",00" EVEN if the original number has a decimal place. Like for example 1000.23 will show as 1000,00 with your format. Sam On Sat, Oct 29, 2011 at 3:21 AM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Thanks SAM, > > I missed that

Re: $$Excel-Macros$$ Convert amount to Million

The original code that I gave should have been written within a workbook. But now that you are using an add-in, yes you can use it in a different module, but for it to run, you will have to CALL it when required. Sam On Sat, Oct 29, 2011 at 3:20 AM, Aamir Shahzad wrote: > Can I create another "M

Re: $$Excel-Macros$$ Number Formats in French

Thanks SAM, I missed that part. please find the updated format. Regards Chethan Kumar BN On Sat, Oct 29, 2011 at 3:15 AM, Sam Mathai Chacko wrote: > The OP had requested for the decimal separator to be a comma (,) > > Sam > > > On Sat, Oct 29, 2011 at 3:07 AM, B.N.Chethan Kumar < > chetankumar1..

Re: $$Excel-Macros$$ Convert amount to Million

Can I create another "Module 2" in the same add in & write code there? Aamir Shahzad On Sat, Oct 29, 2011 at 2:43 AM, Sam Mathai Chacko wrote: > Not sure what procedure you require, but if you knew the range, this is how > you'd call this > > your code -- > your code -- > Call

Re: $$Excel-Macros$$ To send mail from excel.

Kurikkal, This is meant to do what you require. I'm sure you can make modifications to your code after looking at this.. http://msdn.microsoft.com/en-us/library/ff519602(v=office.11).aspx#odc_office_UseExcelObjectModeltoSendMailPart2_MailingRangeSelectionBody Regards, Sam On Sat, Oct 29, 2011

Re: $$Excel-Macros$$ Number Formats in French

The OP had requested for the decimal separator to be a comma (,) Sam On Sat, Oct 29, 2011 at 3:07 AM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Hi Kent, > > I have attached the file with custom format. Kindly check if these help. > > Regards > Chethan Kumar BN > > On Fri, Oct 28, 2

Re: $$Excel-Macros$$ Convert amount to Million

Not sure what procedure you require, but if you knew the range, this is how you'd call this your code -- your code -- Call ConvertToMillions(Worksheets("NameOfSheet").Range("A1")) your code -- Private Sub ConvertToMillions(ByRef Target As Range) Dim rngCell As Rang

Re: $$Excel-Macros$$ Convert amount to Million

how? procedure required. On Sat, Oct 29, 2011 at 2:39 AM, Sam Mathai Chacko wrote: > Yes you can > Sam > > > On Sat, Oct 29, 2011 at 3:07 AM, Aamir Shahzad > wrote: > >> Can I enter this code with another add in? >> >> >> On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote: >> >>> Something

Re: $$Excel-Macros$$ Convert amount to Million

Yes you can Sam On Sat, Oct 29, 2011 at 3:07 AM, Aamir Shahzad wrote: > Can I enter this code with another add in? > > > On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote: > >> Something like this might do the trick >> >> Private Sub Worksheet_Change(ByVal Target As Range) >> >> Dim rn

Re: $$Excel-Macros$$ Number Formats in French

Hi Kent, I have attached the file with custom format. Kindly check if these help. Regards Chethan Kumar BN On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles wrote: > Hi guys! > I have a quick question regarding formats. I have to > convert english accounting procedures into French a

Re: $$Excel-Macros$$ Convert amount to Million

Can I enter this code with another add in? On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko wrote: > Something like this might do the trick > > Private Sub Worksheet_Change(ByVal Target As Range) > > Dim rngCell As Range > > For Each rngCell In Target > If Right(UCase(Trim(rngCe

Re: $$Excel-Macros$$ Lookup

Thanks you very much SAM. Aamir Shahzad On Sat, Oct 29, 2011 at 2:32 AM, Sam Mathai Chacko wrote: > 1 will look for matching values in the 1st column, and 3 will give results > from 3rd column! > > Sam > > > On Sat, Oct 29, 2011 at 3:00 AM, Aamir Shahzad > wrote: > >> SAM one last question is

Re: $$Excel-Macros$$ Lookup

1 will look for matching values in the 1st column, and 3 will give results from 3rd column! Sam On Sat, Oct 29, 2011 at 3:00 AM, Aamir Shahzad wrote: > SAM one last question is =MultiResultLookedUp(B3,*1*,$F$3:$H$42,3) > 3 is understandable that it's column 3 but what is 1 in Red font. > > Aami

Re: $$Excel-Macros$$ Lookup

SAM one last question is =MultiResultLookedUp(B3,*1*,$F$3:$H$42,3) 3 is understandable that it's column 3 but what is 1 in Red font. Aamir Shahzad On Sat, Oct 29, 2011 at 2:19 AM, Sam Mathai Chacko wrote: > Just change =MultiResultLookedUp(B3,2,$F$3:$I$42,*1*) to > =MultiResultLookedUp(B3,2,$F$

Re: $$Excel-Macros$$ Convert amount to Million

Something like this might do the trick Private Sub Worksheet_Change(ByVal Target As Range) Dim rngCell As Range For Each rngCell In Target If Right(UCase(Trim(rngCell.Text)), 1) = "M" Then rngCell.Value = Replace(UCase(Trim(rngCell.Text)), "M", "") * 10 ^ 6 En

$$Excel-Macros$$ Convert amount to Million

Dear Experts, Is it possible in excel that if I write in cell "1M" & press tab or enter it automatically converted this figure to 1,000,000. or 4.5M to 4,500,000. Regards, Aamir Shahzad -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

Re: $$Excel-Macros$$ Lookup

Just change =MultiResultLookedUp(B3,2,$F$3:$I$42,*1*) to =MultiResultLookedUp(B3,2,$F$3:$I$42,*3*) to look at second column and pick value from 3rd column Sam On Sat, Oct 29, 2011 at 2:46 AM, Aamir Shahzad wrote: > > SAM this is working marvelous from left side but tell me (SYNTAX) now to picked

Re: $$Excel-Macros$$ Lookup

SAM this is working marvelous from left side but tell me *(SYNTAX)* now to picked up the right side values from columns 2nd or 3rd. Because this code is not giving the values from right side now. On Sat, Oct 29, 2011 at 1:24 AM, Sam Mathai Chacko wrote: > Is this just for whims? Or are you just i

$$Excel-Macros$$ Nuance of the .Zoom print scaling parameter

I just spent some hours figuring this out, so I'll post this here in case anyone searches on this in the future. In Page Setup the user can adjust print scaling to "Adjust to" and enter a zoom percentage, or the user can set scaling to "Fit to" and enter a number of pages wide and number of pages

Re: $$Excel-Macros$$ Number Formats in French

One way is to use # ### ### ### ###\,00 The catch is that you'll have to write your numbers in 00s. So to convert one thousand in this format 1 000,00 you will have to write one hundred thousand 10 Regards, Sam On Fri, Oct 28, 2011 at 11:58 PM, HarryP Knuckles < kent.bouc...@tbs-sct.gc.ca>

$$Excel-Macros$$ To send mail from excel.

Can somebody help me on this. -- Forwarded message -- From: kurikkal padinjarappalla Date: Thu, Oct 27, 2011 at 11:35 PM Subject: $$Excel-Macros$$ Re: To send mail from excel. To: excel-macros@googlegroups.com Attachment... On Thu, Oct 27, 2011 at 11:34 PM, kuri

Re: $$Excel-Macros$$ Lookup

Is this just for whims? Or are you just intrigued? =MultiResultLookedUp(B3,2,$F$3:$I$42,1) will look at the second column and pick values from 1st column Public Function MultiResultLookedUp(varLookupValue, lngLookAtCol As Long, rngRange As Range, Optional lngCol As Long) As String Dim lngLoo

Re: $$Excel-Macros$$ Want to learn Match and Offset - formulas

Thanks Sir. On Fri, Oct 28, 2011 at 9:08 AM, NOORAIN ANSARI wrote: > Dear Indarjit, > > Please see attached PFD, Hope it help to u > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.com

Re: $$Excel-Macros$$ Lookup

Now resolved thanks. Any possibility for pickup the left side values? Aamir Shahzad On Fri, Oct 28, 2011 at 11:20 PM, Sam Mathai Chacko wrote: > Just specify the column index > > Public Function MultiResultLookedUp(varLookupValue, rngRange As Range, > Optional lngCol As Long) As String > >

Re: $$Excel-Macros$$ Fuzzy Matching

Why not attach a file with a better explanation. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: SHC Sent: Friday, October 28, 2011 6:41 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Fuzzy Matching I've been using Microsoft Fuzzy Lookup Add-In

Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet

What you do NOT understand that is if you do it your way, it will be a separate filter and delete rows for each item. You could use a SELECTCASE method with a loop from the bottom up to inspect each cell. Again, slow I STRONGLY suggest that you adapt my suggested method... Don Guillett Sales

Re: $$Excel-Macros$$ Number Formats in French

Hi sam, Thanks for your response. The reason I am interested in the custom format is that i have two langauges within the same workbook and the advice you provided affects the entire workbook. If you could provide with the custom format instructions; it would be greatly appreciated.

Re: $$Excel-Macros$$ Lookup

Just specify the column index Public Function MultiResultLookedUp(varLookupValue, rngRange As Range, Optional lngCol As Long) As String Dim lngLoop As Long Dim lngDefaultCol As Long: lngDefaultCol = 2 Dim varArray varArray = rngRange If lngCol <> 0 Then lngDefaultCol = lngCol

Re: $$Excel-Macros$$ Number Formats in French

Instead of putting a custom format, why don't you change the comma separator and decimal separator to space and comma respectively? Regards, Sam On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles wrote: > Hi guys! > I have a quick question regarding formats. I have to > convert engli

Re: $$Excel-Macros$$ Lookup

Good result but if 3rd 4th or other column required, this macro only give result of next column only. Need further enhancement. Regards, Aamir Shahzad On Thu, Oct 27, 2011 at 11:39 PM, Sam Mathai Chacko wrote: > Public Function MultiResultLookedUp(varLookupValue, rngRange As Range) As > String

Re: $$Excel-Macros$$ UnProtect Code Not working

In your code above, you use another user name to unprotect it. And here you protect it after checking for another user name. Please standardize and then recheck. On top of that, you are counting for the number of Worksheets, and applying protection on Sheets. Please understand Sheets and Worksheets

Re: $$Excel-Macros$$ UnProtect Code Not working

thanks for your reply Sam but your conclusion is not right.. below is the code which I am using to protect the sheets and as you can see the password is same. "Sample". Please advice. == Sub prot() Dim sht As Integer Dim uname As String uname =

$$Excel-Macros$$ Number Formats in French

Hi guys! I have a quick question regarding formats. I have to convert english accounting procedures into French accounting procedures. In English one thousand dollars is equal to $1,000.00. In French one thousand dollars is equal to 1 000,00. the difference is that the comma before a

Re: $$Excel-Macros$$ UnProtect Code Not working

It means the sheet is protected with another password, and that you cannot unprotect the sheet using a password that does not match. Sam On Fri, Oct 28, 2011 at 9:16 PM, Anish Shrivastava wrote: > Hi, > > Please see the code below, when I run the code it says "password you > supplied is not vali

$$Excel-Macros$$ VBA Job @ Ernst and Young , Gurgaon

Dear members, E&Y(Gurgaon) looking out for VBA professionals with 1-2 years of experience. Refer your friends and send me resume @ jainayus...@gmail.com. Please do not post any resume in forum and send it to me only. Thanks. -- Best regards, Ayush Jain -- FORUM RULES (925+ members already B

$$Excel-Macros$$ UnProtect Code Not working

Hi, Please see the code below, when I run the code it says "password you supplied is not valid". === Sub unpro() Dim sht As Worksheet Dim uname As String Dim pwd As String uname = Environ("Username") pwd = "Sample" For Each sht In Worksheets If uname = "anisku

Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet

Hi Don, it is part of the requirement. however, the "MYLIST" seldom change so I intently hard code into it first. For others, it is too complicate too I think. Please refer to my new file. The requirements are more concrete. Thanks. Darwin 2011/10/28 dguillett1 > Let me see your file(s) aft

Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet

Let me see your file(s) after you redo it. Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Friday, October 28, 2011 9:55 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet Thanks Don,

$$Excel-Macros$$ Fuzzy Matching

I've been using Microsoft Fuzzy Lookup Add-In for Excel in Excel 2010, but in the last few days it's decided it doesn't want to perform the matching (the pane loads fine). Is anyone else experiencing this problem? Does anyone know of an alternative method for fuzzy matching in Excel 2010 that allow

Re: $$Excel-Macros$$ Find last number in a column with numbers

Another way .defined name colB name Data =OFFSET(Sheet1!$B$1,0,0,MATCH(99,Sheet1!$B:$B),1) in the series data type in =dsc.xlsm!colb name Dates =OFFSET(colB,0,-1) Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Thursday, October 27, 2011 3:40 PM To: exc

$$Excel-Macros$$ record a macro

Hi Experts, Is there any way to record a macro between applications? Thanks Akhilesh Airen -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Time between " "

That's because the original request said that he was looking for: "hour=" & & Cells(i,6 )& Not "Time=" & & Cells(i,6 )& So, I "assumed" that he was wanting the hour, not the time. silly me. --- For TIME, the simplest version would be: Cells(I, 15).Value = "hour="

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 6 Messages in 4 Topics

Dear Mr. Naidu, Please see attached sheet, Hope it help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Oct 28, 2011 at 4:15 PM, ck naidu w

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 6 Messages in 4 Topics

Hi Macros..., I am preparing an excel sheet with validation it should not allow the special characters in a coloumn. Suppose we entered specail character in between the word, the cell should format like red color. pls help urgent. Thanks Sai. On 28 October 2011 05:

Re: $$Excel-Macros$$ Time between " "

Mr. Chacko, works perfectly. Thanks a lot!! Best Regards On 28 out, 01:38, Sam Mathai Chacko wrote: > Cells(I, 15).Value = "hour=" & & Format(Hour(Cells(I, 6).Value),"00") > &":" > & Format(Minute(Cells(I,6)), "00") & > > Regards > > Sam > > On Fri, Oct 28, 2011 at 6:20 AM, Eduardo Ce

Re: $$Excel-Macros$$ Require some free MIS template.....

Dear Shashi, Please try through below linkit will be usefull for u. http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html http://www.techrepublic.com/blog/10things/10-tips-for-working-more-efficiently-in-excel/203 another option... 1. Save your file in .xlsb exten

Re: $$Excel-Macros$$ Require some free MIS template.....

Dear Noorain Sir I have some files whose file sizes is 10MB to 20 MB and when i open these files in any version of office either 2003 or 2007 files is very slow to open so is there any excel addin which can compress the size or reduce the time of opening the file. Thanks Sir Shashi Ranjan On O

Re: $$Excel-Macros$$ doubt

You could always use the data in Excel as a linked table in Access, and create reports as from a normal access database table. Sam On Fri, Oct 28, 2011 at 1:16 PM, Shankar Bheema wrote: > Hai All, > > I created a calculation form in EXCEL 2003 VBA. I placed save, update and > etc commands on th

$$Excel-Macros$$ doubt

Hai All, I created a calculation form in EXCEL 2003 VBA. I placed save, update and etc commands on the VBA form. The data which I enter will save in excel format. Is it possible to prepare reports using MSACCESS 2003 for generating reports using the stored data in excel ? -- FORUM RULES (925+