RE: $$Excel-Macros$$ Re: dbf conversions

Excel 2007+ can import DBF files, but not save to them. Excel 2003 and prior allow saving as Dbase (DBF) files. A few alternsatives for saving/exporting to DBase DBF files: .Excel 2003 and prior versions .LibreOffice https://www.libreoffice.org (open source office suite) supp

RE: $$Excel-Macros$$ How to creat circle on cells

Hi Pankaj, If you want circles around the cells with values less than 30, there are two methods that come to mind. (1)Use a data validation rule that specifies that values >= 30 are the only valid values (you can disable all warnings in the data validation rule so it will allow entry of value

RE: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

Very nice calendars. I like how Deba Ranjan's has a month offset feature (Seems to be a hidden feature) by changing the value in G4, for a calendar that begins on any month of the year. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schrein

RE: $$Excel-Macros$$ How to make Outline work in Protection

se of protection is to hide Formula's. regards, Zeeshan On Thu, Dec 6, 2012 at 9:33 AM, Asa Rossoff wrote: Hi Zeeshan, You can enable outlining on protected sheets by use of some simple VBA code. There is a protection option available only via VBA called "UserInterfaceOnly".

RE: Fwd: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

Congratulations Paul! I really appreciate your generosity, expertise, and communication skills. I'm happy to see you honored for your contributions. You have an EXCELLENT point about the challenges so many here rise above beyond just the technical. I have great respect for the group as a whol

RE: $$Excel-Macros$$ How to make Outline work in Protection

Hi Zeeshan, You can enable outlining on protected sheets by use of some simple VBA code. There is a protection option available only via VBA called "UserInterfaceOnly". It's purpose is to allow other VBA code to maipulate protected sheets freely, but have the sheets otherwise stay fully prote

RE: $$Excel-Macros$$ Scraping data from image

P.S., Hanumant, here is a link with detailed instructions for using OneNote for OCR: http://www.howtogeek.com/howto/14595/ocr-anything-with-onenote-2007-and-2010 / Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Friday, November

RE: $$Excel-Macros$$ Scraping data from image

Hi Hanumant Shinde, Yes, as others have mentioned, you can use OCR (Optical Character Recognition) software. In fact, Microsoft Office comes with OCR capability built-in. Another alteernative is Adobe Acrobat, if you have that. Most scanners and printer/scanners also come with OCR software.

RE: $$Excel-Macros$$ VBA macro quiz #1

I like the questions. Very good introductory questions on a variety of VBA topics. For question #8, I suspect the question intended could be better phrased "Which of these is a datatype most specifically for storing decimal integers in a variable?" (several of the datatypes listed store decima

RE: $$Excel-Macros$$ VBA : Class does not support automation error.

Hi Amol, I haven't use the Office Web Components, and we don't know much about your code or file, but the error is usually caused by a references/library problem, such as: .You used early binding but the reference to the OWC library was broken. .The OWC library is not installed o

RE: $$Excel-Macros$$ Macro for convert to Million

Hi Aamir, How did the add-in I designed for you last time workout? Does it need a modification? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Thursday, October 04, 2012 10:45 PM To: excel-macros@googlegroups.com Subject: $$

RE: $$Excel-Macros$$ Excel 2010 VBA Priority

Hi Paul, I don't know the answer to your whole question, but using DoEvents periodically should ensure you can interrupt the macro, that screen painting can occur, and that the Excel application window can respond to events. Perhaps issue this at the same time as your statusbar update. Windows

RE: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

Hi Aamir, Not sure exactly what you're after (haven't seen your workbook), but perhaps this is helpful: { =TRANSPOSE(INDEX(TRANSPOSE(ColumnsOfTableYouWantReturned),,MATCH(WhatValueTo Lookup,LookupRange,0))) } If your values to return are all numbers, you can use this instead: { =INDEX(--Colu

RE: $$Excel-Macros$$ Re: Request for support for a looping macro

ober 20, 2012 5:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Request for support for a looping macro I wonder if it would speed it up if you set calculation to xlmanual? Regards David Grugeon On 21 October 2012 03:23, Asa Rossoff wrote: > Hi Diamond Dave,

RE: $$Excel-Macros$$ VBA Code Related Question

) So I will try it to export only certain chart.There are any option in excel 2003 for sparklines,piechart,barchart in single cell then I will not try to export chart from other file Regards Amar On Thu, Oct 18, 2012 at 12:23 PM, Asa Rossoff wrote: Hi Amar, I examined your file, and it seems

RE: $$Excel-Macros$$ VBA Code Related Question

chart not change when I change value data in Data sheet,there is any mistek by me Pls tell me Regards Amar On Thu, Oct 18, 2012 at 8:30 AM, Asa Rossoff wrote: Hi Amar, In your attached file, there is no VBA code attached to the worksheet itself, thus there is nothing to copy or move. Th

RE: $$Excel-Macros$$ VBA Code Related Question

Hi Amar, In your attached file, there is no VBA code attached to the worksheet itself, thus there is nothing to copy or move. The VBA code in your file (of which there is a lot) is in various other objects: several standard modules, perhaps 15 or 20 class modules, several userforms, and the Th

RE: $$Excel-Macros$$ How to repair corrupted Excel file

Some things you can try: 1. Try opening you file in Office Web Apps. http://skydrive.live.com/ 2. Install open-source LibreOffice and try opening your file in that. http://www.libreoffice.org/ 3. Try opening your spreadsheet using a database connection (See below) 4. Try

RE: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

I'm happy to see you recognized and honored for your continued great contribution Rajan. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Tuesday, October 02, 2012 8:34 AM To: excel-macros Subject: $$Excel-Macros$$ Rajan Verma - Most

RE: $$Excel-Macros$$ Query - Circle Invalid...

There is a Data Validation option to Circle Invalid DAta -- data that does not match the data validation rule for its cell. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel Vba Sent: Thursday, September 13, 2012 8:46 AM To: excel-macros@googl

RE: $$Excel-Macros$$ detecting loggedin user

Hi Midhun, I like Paul's thorough response. I thought I'd mention that there is a simpler / easier-to-remember way of detecting the logged-in user's name from a macro: Function ReturnUserName() As String UserName = Environ("USERNAME") End Function It is slightly less secure, sinc

RE: $$Excel-Macros$$ Need help - To divide the string into three parts

Hi Mangesh, I've read your other replies, and as to why you haven't received a formula method -- most people don't want to take the trouble on a volunteer basis to provide a more complex or difficult solution to a given problem when simple solutions exist. Also in business, the simplest solution

RE: $$Excel-Macros$$ Re: treeview

.com/nb-no/vbrun/ms788708%28en-us%29.aspx. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Monday, September 10, 2012 12:53 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: treeview Hi James, Microsoft gives warnings about runni

RE: $$Excel-Macros$$ Re: treeview

Hi James, Microsoft gives warnings about running 64-Bit office, and notifies users in advance that there will be compatibility issues. With 3rd party components, those issues are pretty much unavoidable, but its true Microsoft could have updated their own various components to 64-bit versions for

RE: $$Excel-Macros$$ Solution for Index array formula

Hi Amar, For the best response to your questions, please explain your question in your email message. In your follow-up message today, which had neither the question nor the attachment, it was impossible to tell what you needed help with without checking the list archives! Here is a solut

RE: $$Excel-Macros$$ Re:

To Harshad: In Excel 2010 you can use the DisplayFormat object, which indicates the range (cell) format properties as actually displayed, including conditional format and table style effects. Bob Phillips and Chip Pearson have both published functinos that can evaluate the color of a cell acc

RE: $$Excel-Macros$$ I want to Learn Array Formulas

I don't know the book, but here it is. Rajan had a small typo in the author's name, perhaps that was the difficulty: http://www.amazon.com/Microsoft-Functions-Formulas-Edition-Computer/dp/19364 20015/ref=pd_bxgy_b_text_y/185-8930763-6171505 Or the downloadable Kindle Edition: http://www.amazon.c

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congratulations Noorain. You are a real asset. Agreed that the certificate is a great idea. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday, September 05, 2012 6:55 AM To: excel-macros@googlegroups.com Subject: R

RE: $$Excel-Macros$$ Change Column Size

Additionally, although it is quite possible to detect when one of the data-val. cells has been selected, perform a task, then when another cell's been selected, reverse the original task (mburkett -- you'll need to track some data between events to do that), your code then has to figure out how wid

RE: $$Excel-Macros$$ Baler Software

> Please don't ban me (I won't do it again) indicates foreknowledge and intent! -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Congratulations Noorain! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Friday, August 03, 2012 10:40 AM To: excel-macros Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012 Dear members, Noorain Ansari has be

RE: $$Excel-Macros$$ Failure of code when trying to break a section out into a seperate routine

Hi Anil, Try using the same data types in the calling routine ( PowerReturnOutput ? ) and the called routine ( EnterPN ). > PNArray() and OutputRng have values in the immediate window. When you say they have values, do you mean they have the expected values? Did you check the elements of the arr

RE: $$Excel-Macros$$ macro with multiple rows

Hi Pawel, Here is a short answer to what I think you want. It is a generic solution to the key issue of copying formulas (and only formulas) down to the next row. Dim LastRowRange As Range ... Set LastRowRange = ... ' Determine last row's range here With LastRowRange.SpecialCells(xlCellTy

RE: $$Excel-Macros$$ Error Cleaning

Hi SG, Please provide also a sample of the result you want. If your spreadsheet has rows that do NOT have errors, include some of those in your sample as well. If there are additional columns from the ones you included in the file you already sent, please include them. :) Asa From: excel-ma

RE: $$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

Hi B Sharma, One option not mentioned is to protect the sheet from VBA using the UserInterfaceOnly option. With this option, your VBA code does not have to unprotect the sheet - it has untethered access. The sheet will be protected from direct interaction with the user only. For that, you co

RE: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

Extraorinary contribution, Rajan. Cheers. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Wednesday, July 04, 2012 9:17 AM To: excel-macros Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12) Hello Everyone, Raja

RE: $$Excel-Macros$$ range formatting

Hi Pawel, You can accomplish this simply by using conditional formatting. You can either: 1. Use a default format and a conditional format. a. Format D5:J22 with one of the two formats. This would be your default format regarldess on the value in C2. b. Use a conditional forma

RE: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

;bigger" than the other, we charge considering the highest value. i´m trying to do this with a table concatenating all the values and then using lookups, let´s see if I can succeed. 2012/6/29 Asa Rossoff Hi Jorge, Looks like this can be handled using lookup formulas. One good way to perfor

RE: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Sorry to hear that. Your work is still valued by many, Don. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, July 01, 2012 10:04 AM To: excel-macros Cc: Dilip Pandey; ashish koul Subject: Re: $$Excel-Macros$$ MVP AwardCon

RE: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Congratulations Ashish and Dilip! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Sunday, July 01, 2012 9:25 AM To: excel-macros Cc: Dilip Pandey; ashish koul Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip

RE: $$Excel-Macros$$ Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

p.s. oops, so sorry, though you had posted a new quesiton :) not sure how I got to reading old posts. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Saturday, June 30, 2012 7:36 PM To: excel-macros@googlegroups.com Subject: RE

RE: $$Excel-Macros$$ Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

Hi H, .Text = bad :) If you mean that the date is on the worksheet as text insead of as a date(dateserial). if the date matches the system local settings (i.e. date is in m/d/y format, your computer is set to m/d/y format) you can just use any of the methods I listed in my last post without any

RE: $$Excel-Macros$$ For Each loop

You also might want to consider using a worksheet.change event to modify the locked status on a given row range when and only when values in column X are changed. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Saturday, June 30, 2012 6

RE: $$Excel-Macros$$ For Each loop

Hi Richard, Here's my approach: Sub prototype() Const ColumnlarCriteria As String = "X3:X1000<>5" Dim LockRange As Range Dim LockRow() As Variant Dim Row As Long With Sheet1 .Protect userinterfaceonly:=True Set LockRange = .Range("Y3:AX1000") LockRow() = Wor

RE: $$Excel-Macros$$ Copy JPG images from Word into Excel

Hi Paul, I have not automated Word much.. so these are just some thoughts: Have you already tried these ideas? 1) export from Word as MHT (images will be emebedded with the html file to reduce file clutter), then open the file in Excel. 2) Open the document in Word, Select All, Cop

RE: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

Hi Jorge, Looks like this can be handled using lookup formulas. One good way to perform lookups is to have a number representing each of your criteria each alone in their own cell, preferably all in the same table for all transporters. You can use pivot tables to generate the cross referenced

RE: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

me for you. The example I posted seemed to work but I admit I did not check to see if the correct day was returned. Tomorrow I will do that and try out your format function version (which I think someone else posted earlier but I had not tried it yet). On Wed, Jun 27, 2012 at 9:35 PM, Asa R

RE: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

Hi! Hope you are well. The "VBA way" is to use VBA's Format function (Replace CELL with the range object for the cell desired): Format(CELL.Value2, "") If you wanted to use the TEXT function, the example given -- I believe -- will return incorrect results. These versions would return

RE: $$Excel-Macros$$ Saving Photos from webpage

Hi Kiran, I can help you off-list to meet your need exactly, for a reasonable fee. But first I will offer you some free advice and hints: 1. The product search results in a URL like "http://www.jabong.com/catalog/?q=WR138MA56HVN+

RE: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell

isibleCellColumns = Nothing End Sub Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Saturday, June 16, 2012 6:43 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only th

RE: $$Excel-Macros$$ Find Narrow Cells & Appying Auto fit to only that cell

Prashant: My guess is that your request is for a macro that will only Auto-Increase column widths -- never decrease them, which would unneccesarily change the look of the spreadsheet. Excel does not have a method of specifically identifying cells (or columns) where text has "overflowed", but I

RE: $$Excel-Macros$$ Translating

Good day Kiran, To manually translate, you can go to the Research task pane > select Translation > select language pair > search for a word or phrase. .A quick way to get there is to ALT-Click a cell with text you want to translate to bring up the Research pane with that text pre-enter

RE: $$Excel-Macros$$ Updating multiple excel workbooks

Hi Shoodie, Do you still need help with this? There are several ways to find the files you need to edit, depending on your target Excel versions, platforms (mac/windows), and security settings on the target operating system. Perhaps the most cumbersome of the available methods is the Dir c

RE: $$Excel-Macros$$ Text Cleaning

Character End If Next Position CleanText = NewText End Function By the way, welcome to the group! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Monday, June 04, 2012 8:38 AM To: excel-macros@googlegroups.com Subjec

RE: $$Excel-Macros$$ Text Cleaning

: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Monday, June 04, 2012 8:38 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Text Cleaning Hi Sonal, Another function for you: Function CleanText(Text As String) As String Dim New

RE: $$Excel-Macros$$ Text Cleaning

Hi Sonal, Another function for you: Function CleanText(Text As String) As String Dim NewText As String, Character As String * 1, Position As Long For Position = 1 To Len(Text) Character = Mid(Text, Position, 1) If Character Like "[A-z]" Or Character Like "#" Then

RE: $$Excel-Macros$$ Date format calculation

groups.com Subject: Re: $$Excel-Macros$$ Date format calculation Dear Asa, Can you please explain in the sheet itself. Thanks & Regards, Deba Ranjan P On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote: Hi Deba, For the Login Time column, the reason SUM is not working pr

RE: $$Excel-Macros$$ Date format calculation

Hi Deba, For the Login Time column, the reason SUM is not working properly is that many of the login times are being interpreted as text instead of as [h]:mm:ss entries. 1) For the login time column with a custom format: [h]:mm:ss or the corresponding preset "Time" format: 37:30:55 2)

RE: $$Excel-Macros$$ Creating links to workbooks in folder using VBA

Hello Hugo, Please post your current macro and we can most easily give you your desired update to it. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hugo.ph...@gmail.com Sent: Sunday, June 03, 2012 2:24 AM To: excel-macros@go

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

t the last occurance which I think might be useful going forward. Thanks again Sent from my BlackBerryR smartphone from Airtel Ghana _ From: "Asa Rossoff" Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 02:42:58 -0700 To: ReplyTo: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

Congratulations Rajan! Outstanding work. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Sunday, June 03, 2012 10:43 AM To: excel-macros Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) Hello Everyone, R

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

ll, i will try your now. thanks On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff wrote: Hi Hilary, Mind sharing your solution with the group? What came to mind for me was an array solution that uses small/row to identify the second smallest row number for the matching name, and index to retrie

RE: $$Excel-Macros$$ Require Business related PPT presentation template.....

Hi Indrajit, You could try searching @ Office.com; for example: http://office.microsoft.com/en-us/templates/results.aspx?qu=business &ex=1&av=zpp Asa From: excel-macros@googlegroups.com [mailto:excel-macros@g

Free Ebooks (RE: $$Excel-Macros$$ MACRO)

I haven't said anything in the past, thinking it may just be a culture difference -- But now I will offer my opinion: I too am against sharing pirated material. I have seen apparently pirated ebooks posted, linked to, or offered on this list many times. I have also seen copy-paste responses

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

Hi Hilary, Mind sharing your solution with the group? What came to mind for me was an array solution that uses small/row to identify the second smallest row number for the matching name, and index to retrieve the reference to the cell. Here's a formula using that approach: { =INDEX(NamesRan

RE: $$Excel-Macros$$ can we round figer any amount.

Hi Anil, To get the exact results you indicated (10% of rounding up to next 100,000), you can use any one of these formulas: =ROUNDUP(A2,-5)/10 =ROUNDUP(A2/10,-4) =(INT(A2/10)+(A2/10<>INT(A2/10)))*1 The ROUNDUP formulas will work with positive or negative numbers, but if

RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell

Lakshman ( & Deba ) - Rajan posted an excellent formula for extracting all the numbers already. Make sure to enter his formula with ctrl-shift-enter (it's an array formula). It is for Excel 2007+ only because it uses the IFERROR function. Here is a version modified slightly to work in olde

RE: $$Excel-Macros$$ SOAP and VBA

Hi Rocky, For Office XP and 2003 there was something called the Web Services Toolkit that provided a a library for this purpose. This is an "unsupported method", and may always have been "unsupported". The supported method is to use .NET Ofiice Interop and code your solution in Visual Studio.

RE: $$Excel-Macros$$ REMOVE ME

Best not to quote my old post that indicates that a "remove me" subject will work. Google Help says so, but it doesn't look to be true. I and with Rajan in recommending to just send a blank email to excel-macros+unsubscr...@googlegroups.com to remove yourself from the group. From: excel

RE: $$Excel-Macros$$ Row to repeat at the bottom of each page

page Hi Asa Yes I did the same, I copied the content in paint saved as a bmp file and attached in the footer and its working fine thanks Siraj From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Friday, May 18, 2012 12:19 PM To

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

Hi Aamir, How about this: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False MacroMillion Target Application.EnableEvents = True End Sub Private Sub MacroMillion(ByRef Target As Range) Const M As Double = 100 Const EvalMethodMinCellThres

RE: $$Excel-Macros$$ Row to repeat at the bottom of each page

iraj Momin (BTG) Sent: Thursday, May 17, 2012 9:34 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Row to repeat at the bottom of each page Hi Asa Rossoff Thank You for your advice, actually the problem is it is an small box with border are there which I want to repeat at

RE: $$Excel-Macros$$ VBA If statement

Hi Burbonizer, See if the following does what you want. It modifies your code to require both conditions for the field you printed in red to be made visible. If either condition is false, the field is made invisible again. If me.active_statuts = "IH" then Me.Input1.SetFocus Me.Button

RE: $$Excel-Macros$$ Row to repeat at the bottom of each page

Hi Siraj, I do not think so. Not automatically. You would have to have the rows repeated on your worksheet at appropraite places, or use a macro to temporarily insert those rows, print the sheet, and then remove them again. The most common solution, I think, is to use the page footer inst

RE: $$Excel-Macros$$ Link Check Box many times

Hi Hilary, You could use a character with a check box, and a Worksheet.Click event to place and remove the checks. You can use the Windows Character Map utility (charmap.exe) to browse your fonts. Unicode includes a Ballot Box character (☐), Ballot Box with Check (☑) and Ballot Box with X (☒)

RE: $$Excel-Macros$$ Formula for discount of third item bought by a customer

From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Tuesday, May 15, 2012 3:19 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Formula for discount of third item bought by a customer Hi Robinson, To my way of looking at it, the problem is rather c

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

$$ Re: Printing sheets in colour using VBA in ecel yes. Just like that. But , the macro doesn't print in colour. Sunny On Mon, May 14, 2012 at 10:00 PM, Asa Rossoff wrote: Sunny, when you say "manually print in color" how do you do that? Do you click on Printer Settings or

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Sunny, when you say "manually print in color" how do you do that? Do you click on Printer Settings or Page Setup to select that option? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sunny Kapoor Sent: Monday, May 14, 2012 12:55 PM To: excel-mac

RE: $$Excel-Macros$$ Need help-- Related to UDF

Function Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Monday, May 14, 2012 12:41 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need help-- Related to UDF Hello Amol, Sounds like you are asking for something

RE: $$Excel-Macros$$ Need help-- Related to UDF

Hello Amol, Sounds like you are asking for something like this: Function LookupSomething(LookupValue, TableArray) Const ColIndex 3, RangeLookup = True LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray, ColIndex, RangeLookup) End Function Modify the Const line for the VLO

RE: $$Excel-Macros$$ amend in macro

OOps, typos -- Sub Sheet1Multiplecopy() Dim s1 as worksheet, n as long set s1=worksheets(1) For n = msgbox("How many sheets do you want to add?") to 1 step -1 s1.Copy After:=s1 ActiveSheet.Name = n Next s1.select End Sub From: Asa Rossoff

RE: $$Excel-Macros$$ amend in macro

Sub Sheet1Multiplecopy() Dim s1 as worksheet, n as long, c as long c = worksheets.count set s1=worksheets(1) For n = msgbox("How many sheets do you want to add?) to 1 step -1 s1.Copy After:=s1 ActiveSheet.Name = n Next s1.select End Sub From: exce

RE: $$Excel-Macros$$ query

Hi Aamir, You can use =SUMPRODUCT(SUBTOTAL(9,OFFSET($I$10,ROW($I$11:$I$100)-ROW($I$10),)),--($A2=$ H$11:$H$100)) in C2 and copy down. It will work for a filtered list like SUMIF. change the SUBTOTAL type from 9 to 109 to have it ignore rows that are manually hidden as well. Best not to use

RE: $$Excel-Macros$$ Re: Defining Same Name For ranges available in multiple tabs

Nice solution, Haseeb. Works for me in Excel 2010. This method worked with named ranges. If you use the same range name on each worksheet, you can use: =SUMPRODUCT(SUMIF(INDIRECT("'"&$D$1:$D$10&"'!WBS"),A1,INDIRECT("'"&$D$1:$D$1 0&"'!COST"))) Asa From: excel-macros@googlegroups.com [mai

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

a From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Friday, May 11, 2012 8:18 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs Hi Shekhar, You can use: =SUMIF(

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

Hi Shekhar, You can use: =SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(she et3!WBS,A1,sheet3!COST) Or, if the ranges are identical on each sheet, you can use 3-D references with certain functions (but not with SUMIF) to refer to basically a "union" of the identical

RE: $$Excel-Macros$$ Interview Questions with Answers (Excel+VBA+Access+SQL Server)

Thank you Noorain for sharing those. I just started reading through "50 Excel VBA Oral Questions." and the Q & As seem good, but not all the answers are complete and thorough, and some could be misleading. For example: "Ques 06. Difference between ActiveX and Form Controls. Solution: i) Fo

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

thx Asa Rossoff Chilexcel 2012/5/10 Asa Rossoff : > Excellent.  I hope I didn't give the impression I was unwilling to help > more.  I am happy to.  But if you need more help, I prefer a specific > question than just giving a complete solution... so you can gain the most >

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

acros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Thursday, May 10, 2012 12:54 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting Hi Asa Rossoff I'm working on a solution, wi

RE: $$Excel-Macros$$ Replacement of Lookup function

Hi Shekhar, Well, the prupose of the formula is, in the end, to lookup a text value based on an input value. This is best accomplished with a lookup function. ANY of the lookup functions could be used - LOOKUP, HLOOKUP, VLOOKUP, CHOOSE, INDEX, etc. Here is a version that utilizes SUMPRODUCT,

RE: $$Excel-Macros$$ Fwd: Need help on data

Hello Bé Trần, I believe that is what Lokesh meant (sheet1 = data entry form; sheet2 = database record storage) -- but I am replying just to provide the suggestion that you type your replies at the top of messages -- I often have difficulty finding your comments, since they are buried down belo

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

@googlegroups.com Subject: Re: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting Thx Asa Rossoff ,all this I know, also the links Please Rajan you help !!! ... Chilexcel 2012/5/7 Asa Rossoff : > Chil, > Also see Bob Phillip's method @ > http:/

RE: $$Excel-Macros$$ Fwd: Need help on data

Hello Lokesh, You may want to try Debra Dalgleish and Dave Petersen's method detailed here: http://contextures.com/exceldataentryupdateform.html Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: Tuesday, May 08, 2012 7:30 AM To: e

RE: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 Messages in 2 Topics

012907a3b9af3> Table data fit the page size..(auto) "Asa Rossoff" May 08 01:36PM -0700 I see you already have it fit to page when printed - Do you mean you want to have the table forced into the shape of the page to completely fill the page? If so, I think you will ne

RE: $$Excel-Macros$$ Date Problem

hilary, Instead of TEXT(MONTH(TODAY()),"mmm"), I think you were aiming for TEXT(TODAY(),"mmm"). You could also use =TODAY() with a cell format of mmm to have it displayed as Jan/Feb/etc. but still hold a dateserial as the underlying value of the cell. Asa From: excel-macros@googlegroup

RE: $$Excel-Macros$$ Table data fit the page size..(auto)

I see you already have it fit to page when printed - Do you mean you want to have the table forced into the shape of the page to completely fill the page? If so, I think you will need a macro, and it could be a bit tricky. You currently have a macro adjusting the margins in the Workshe

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

Chil, Also see Bob Phillip's method @ http://www.xldynamic.com/source/xld.CFConditions.html -Original Message- From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Monday, May 07, 2012 4:08 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Count & su

RE: $$Excel-Macros$$ Count & sum color cell, cells have conditional formatting

Excel has no function to determine conditional formats of cells -- you have to evaluate the same formulas used to color the cells again yourself to determine what color/format the cell will have received. The "simplest" solution is probably to use VBA to evaluate the CFs, see http://www.cpearson.c

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

some conditions using macro. It should be assigned to a button. On Mon, May 7, 2012 at 10:43 PM, Asa Rossoff wrote: Hi Excel_Lover, When would you like the Req.No's to be generated? Should they be permanent numbers once calculated, or can the be recalculated at any time (for example w

RE: $$Excel-Macros$$ My First Excel Program

Hi Hilary, looks good! My first question: You're a 14 year old single mom?! And an Excel whiz to boot. Please update on how it is coming along, and I will try to help with some of your remaining troubles! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

  1   2   3   4   >