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)
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
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
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
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
of protection is to hide
Formula's.
regards,
Zeeshan
On Thu, Dec 6, 2012 at 9:33 AM, Asa Rossoff a...@lovetour.info 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. It's
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.
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
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 decimal
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
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:
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:
{
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 a...@lovetour.info wrote:
Hi Diamond Dave,
I
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 a...@lovetour.info wrote:
Hi Amar,
In your attached file, there is no VBA code attached to the worksheet
itself, thus there is nothing to copy
) 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 a...@lovetour.info wrote:
Hi Amar,
I examined your file
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
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
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
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:
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
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
-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 running 64-Bit office, and notifies users in
advance that there will be compatibility
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
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, since
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:
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
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:
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
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
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
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
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
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:
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,
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
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
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
and then
using lookups, let´s see if I can succeed.
2012/6/29 Asa Rossoff a...@lovetour.info
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
Hi Richard,
Here's my approach:
Sub prototype()
Const ColumnlarCriteria As String = X3:X10005
Dim LockRange As Range
Dim LockRow() As Variant
Dim Row As Long
With Sheet1
.Protect userinterfaceonly:=True
Set LockRange = .Range(Y3:AX1000)
LockRow() =
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
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
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
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 Rossoff a...@lovetour.info wrote:
Hi
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
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,
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+
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
@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
that cell
Prashant:
My guess is that your request is for a macro
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-entered
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
= 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
Subject: RE: $$Excel-Macros$$ Text Cleaning
Hi Sonal
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)
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
@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 NewText As String
On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info 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
retrieve the reference
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,
occurance which I think might
be useful going forward. Thanks again
Sent from my BlackBerryR smartphone from Airtel Ghana
_
From: Asa Rossoff a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 02:42:58 -0700
To: excel-macros@googlegroups.com
ReplyTo: excel-macros
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:
Hi Indrajit,
You could try searching @ Office.com; for example:
http://office.microsoft.com/en-us/templates/results.aspx?qu=business
http://office.microsoft.com/en-us/templates/results.aspx?qu=businessex=1a
v=zpp ex=1av=zpp
Asa
From: excel-macros@googlegroups.com
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
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:
{
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/10INT(A2/10)))*1
The ROUNDUP formulas will work with positive or negative numbers, but if
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
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.
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
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
(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 bottom
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
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
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 complicated
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
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:
: 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 a...@lovetour.info wrote:
Sunny, when you say manually print in color how do you do that?
Do you click on Printer Settings or Page
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
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:
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 [mailto:a
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) Forms
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
-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(sheet1!WBS,A1,sheet1
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
@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, with the help
Rossoff
Chilexcel
2012/5/10 Asa Rossoff a...@lovetour.info:
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
experience
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
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
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
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:
the page size..(auto)
Asa Rossoff a...@lovetour.info 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 need a macro, and it could
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:
@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 a...@lovetour.info:
Chil,
Also see Bob Phillip's method @
http
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
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
Hi V.Kiran,
If you need to use an exact copy of the bank's form, it may be a bit tricky
in Excel. Whether to use Excel at all, and what approach to take if you
do, depends on the reason you are trying to undertake this.
For example, if you want to use an exact copy of the bank's form, and
Hi Vaibhav,
You got some other good responses.
Here are versions that should be faster for large ranges, since it does not
have to loop through every cell in column A.
It has an important limitation, though: It will only work correctly if
there are at least two of every unique value in
Hi Ashish,
Workbook protection.
http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: Wednesday, May 02, 2012 12:20 AM
To: Excel Macros
Subject: $$Excel-Macros$$
Congratulations Rajan, you're very generous with your time and expertise!
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Wednesday, May 02, 2012 9:01 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan verma : Most Helpful Member-
Hi Pascal,
I'm glad you found the problem (specifying the whole path with Getfile)
With late binding you don't need to set a library reference.
If you don't set a library reference, the constants aren't defined.
You can easily verify the values of the constants in the immediate window
like
Hi Dhanesh,
=SUMIFS(F3:R3,F2:R2,=B3,F2:R2,=C3)
will total the periods whose date (as specified in row 2 -- appears to be
month-ending date) falls between the specified dates in B3 and C3.
=COUNTIFS(F2:R2,=B3,F2:R2,=C3)
will count the number of periods that actually appear in the table and
Hi Pascal,
Actually, my feeling is that your code is leaving a file handle open
unneccesarily and you are having a file sharing/locking violation on FAT32
volumes -- since you only need to have one file handle open at a time, your
code should be correctable (unless VBSCRIPT has some strange bug).
@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Tuesday, May 01, 2012 7:42 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to
a text file
Hi Pascal,
Actually, my feeling is that your code is leaving a file handle open
unneccesarily and you
If you don't want to open the other workbook and you don't want to usa VBA,
I don't know how to COPY a worksheet from one workbook to another, but you
can link to desired values.
For example, in cell A1 of your destination sheet/workbook, type:
=[OtherWorkbookName.XLS]Sheet1!A1
To rerieve
1 - 100 of 359 matches
Mail list logo
