Hi Harry,
The following code line will raise a 'Run-time error 76' error message if Drive
G is not present:
ChDir G:
VBA can use this to make a decision.
Here is a sample code:
Sub changedir()
On Error GoTo ErrorHandler
ChDir G:
'Your normal code goes here
Exit Sub
ErrorHandler:
Hi Harry,
Further to what is below;
If you want VBA to recognise a paticular pen drive to the exclusion of any
other pen drive that might be plugged in, put a unique folder or two on your
pendrive and ask VBA to look for that path. eg:
ChDirG:\HarrysUniqueFolder\HUFSubFolder1
If VBA doesn't
Hi,
If you select List in the Allow: dropdown on the Settings tab of the Data
Validation window, you don't need to use the indirect function.
Just =TEST in the list window will do.
Regards - Dave.
From: jainayus...@gmail.com
Date: Mon, 5 Apr 2010 20:58:32 +0530
Subject: Re:
You're welcome. Glad to help.
Dave.
Date: Tue, 6 Apr 2010 03:47:24 -0700
Subject: Re: $$Excel-Macros$$ VBA VLookup dates
From: andyr...@hotmail.co.uk
To: excel-macros@googlegroups.com
Dave,
Apologies for the late response.
Very much appreciate the effort you have put into this -
Hi Jason,
One way of speeding this up is to use:
Application.ScreenUpdating=False
at the beginning of your code.
(And don't forget the Application.ScreenUpdating=True at the end.)
But I'm sure we could speed it up in other ways as well.
Any chance of attaching the file, or a sample file?
Hi Liu,
Turn on the macro recorder, then do the search manually using Find from the
Edit menu.
When the desired cell is found, stop the macro recorder and go have a look at
the code.
If you need more help, post again.
Regrads - Dave.
Date: Wed, 7 Apr 2010 10:57:10 -0700
Subject:
Agreed.
_
View photos of singles in your area! Looking for a hot date?
http://clk.atdmt.com/NMN/go/150855801/direct/01/
--
Hi,
In VBA:
To put first of month of current date into Cell A2:
Range(A2) = Date - (Day(Date) - 1)
To put current date into Cell B2:
Range(B2) = Date
Hope this helps.
Regards - Dave.
Date: Wed, 14 Apr 2010 14:04:35 +0530
Subject: Re: $$Excel-Macros$$ : How to add the current month Date in
Hi,
This sort of data can usually be cleaned up automatically.
You will need to attach a workbook that contains a few addresses in their
current form, and at least one address in the format you'd like it to be. I'm
sure one of us will be able to help you once we see this.
Regards - Dave.
Hi,
If I understand you correctly, the following line of code does what you ask, to
the active cell.
If Weekday(Date) = 2 Then ActiveCell = Date - 3 Else: ActiveCell = Date - 1
Regards - Dave.
Date: Fri, 16 Apr 2010 10:36:13 +0530
Subject: $$Excel-Macros$$ Excel-Macros : Help
Hi,
If you have both date and time in each cell, then it is a simple subtraction,
with the right formatting in the results cell.
If you only have times, without dates, then XL would have to guess how many
days existed between the two times.
Regards - Dave.
Date: Fri, 16 Apr 2010 00:09:13
-Macros$$ Excel Spreadsheet Cleanup
To: excel-macros@googlegroups.com
Hi there,
I hope this is enough...
On Thu, Apr 15, 2010 at 9:13 PM, Dave Bonallack davebonall...@hotmail.com
wrote:
Hi,
This sort of data can usually be cleaned up automatically.
You will need to attach a workbook
Hi,
This can be done with data validation. Any particular reason you want to do it
with a macro?
Dave.
Date: Mon, 19 Apr 2010 04:11:02 +1300
Subject: Re: $$Excel-Macros$$ Data requeired please help me
From: mam...@gmail.com
To: excel-macros@googlegroups.com
Hi all,
I wanted to write a
Hi,
Are you sure that Date-1 (ie yesterday's date) actually exists in Col C?
Perhaps it appears to exist, but is actually text, not a date.
Regards - Dave.
Date: Mon, 19 Apr 2010 08:18:51 -0700
Subject: $$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet
From:
me to a good course from where I can learn to write
macros...
On Wed, Apr 21, 2010 at 4:31 AM, Dave Bonallack davebonall...@hotmail.com
wrote:
Hi Zac,
Can I suggest a simpler approach?
Using the Ctrl key, select the 2 cells you want to swap, then use a shortcut
key to run this code:
Sub
Hi Wilfred,
You have 2 'spreadsheets'. Is that worksheets or workbooks?
Please attach workbook/s with sample data.
Regards - Dave.
Date: Sun, 25 Apr 2010 18:17:54 -0700
Subject: $$Excel-Macros$$ Help on consolidating inventory data from two
spreadsheets
From:
Hi,
Try this code instead:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
If Sheets(Sheet1).Range(D3) BRIDGESTONE COMPANY INC. Then
MsgBox FILE WILL BE CLOSED!!, vbOKOnly + vbExclamation
MsgBox Please contact EDP
Huh?
Date: Mon, 26 Apr 2010 21:18:44 -0700
Subject: $$Excel-Macros$$ please help me for Excel Conditional formula with
example
From: vikask...@gmail.com
To: excel-macros@googlegroups.com
Dear All,
Please help me for excel condition formula's, pls send formula with example
...pls it's
, Dave Bonallack davebonall...@hotmail.com
wrote:
Hi,
Try this code instead:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Resume Next
If Sheets(Sheet1).Range(D3) BRIDGESTONE COMPANY INC. Then
MsgBox FILE WILL BE CLOSED!!, vbOKOnly + vbExclamation
Sample workbook please. All formatting as origianl, and data you want compared.
Dave
Date: Tue, 27 Apr 2010 07:51:10 -0700
Subject: Re: $$Excel-Macros$$ How to compare two Excel sheets
From: sudhir.p...@gmail.com
To: excel-macros@googlegroups.com
Dear friends , i m waiting for reply,
Hi John,
What is 'StartCellR'?
Also, if you paste this formula {=(Sum(AllBLs*(PF=Range(A6).Value)))} straight
into a cell, you will find that xl won't accept it.
You can't enter VBA notation into a cell.
Try:
=SUM(AllBLs*(PF=A6))
Regards - Dave.
Date: Tue, 27 Apr 2010
Hi,
Try this code in a normal module, and run it while the report sheet is active.
Sub GetSheetInfo()
A = ActiveSheet.Name
B = 2
For Each s In Sheets
If s.Name A Then
Cells(B, 1) = s.Name
Cells(B, 2) = s.Range(A4)
Cells(B, 3) =
Hi,
Try this address:
http://www.contextures.com/tiptech.html
Then go to Data Validation, dependent drop-downs. There are several methods.
Regards - Dave
_
If It Exists, You'll Find it on
You're welcome. I have found the Contextures site very helpful for lots of
tasks.
Regards - Dave.
Date: Sat, 1 May 2010 06:11:26 -0500
Subject: Re: $$Excel-Macros$$ Using an if formula in data validation
From: tanner@gmail.com
To: excel-macros@googlegroups.com
Dave, thank you very
Hi,
Since you have xl2007, try:
=COUNTIFS(A2:A100,1/4/2010,B2:B100,Jumpstart)
Regards - Dave
From: asheeshinsura...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Kndly Solve my Problem
Date: Sun, 2 May 2010 08:47:21 +0530
Dear All,
Please help,
In
You're welcome.
Date: Sun, 2 May 2010 03:18:27 -0700
Subject: Re: $$Excel-Macros$$ Kndly Solve my Problem
From: asheeshinsura...@gmail.com
To: excel-macros@googlegroups.com
Thanks Dave,
Asheesh Arora
--
,
Amanda
On Apr 29, 11:18 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Try this code in a normal module, and run it while the report sheet is
active.
Sub GetSheetInfo()
A = ActiveSheet.Name
B = 2
For Each s In Sheets
If s.Name
Hi Rajeev,
More info please.
Dave
Date: Tue, 4 May 2010 23:42:37 +0400
Subject: $$Excel-Macros$$ Re: Help needed to calculate incentive
From: rajeev1...@gmail.com
To: excel-macros@googlegroups.com
On Tue, May 4, 2010 at 11:40 PM, Rajeev Nandan rajeev1...@gmail.com wrote:
Dear Group
Hi,
See attached.
Regards - Dave.
Date: Wed, 5 May 2010 10:27:42 +0400
Subject: $$Excel-Macros$$
From: dbank...@gmail.com
To: excel-macros@googlegroups.com
hey guys here I attached a file, if u have any solution please help me .
Thanking you,
--
Hi,
A sample file would be good, but to simplify your formula, use a a name for
'Test Plan'!$I$13:$I$10134
I've used XYZ and your formula now looks like this:
=IF(AND(XYZ =11,(IF(SUM(IF(XYZ =NB,1,0)))0,SUM(IF(XYZ
=NB,1,0)),0)+IF(SUM(IF(XYZ =QU,1,0))0,SUM(IF(XYZ
=QU,1,0)),0)+IF(SUM(IF(XYZ
Hi,
Assuming there is a space after the first name, look for that space using
search, then subtract 1:
=SEARCH( ,A1)-1
Change the A1 ref to suit your data.
Regards - Dave.
From: azhar@gmail.com
Date: Wed, 12 May 2010 14:33:26 +0500
Subject: $$Excel-Macros$$ URGENT Request
To:
Hi,
I assume by the leading zeros that the cell is formatted as text.
Try this code, which assumes that your data is in cell E2
Sub InsertComma()
A = 8
B = Len(Range(E2))
Do Until A B
B = Len(Range(E2))
C = Left(Range(E2), A)
D = Right(Range(E2), (B - A))
Range(E2) = C , D
A = A + 9
Loop
formula with the correct addition of
filtering on the date column which is actually in column “M” it will
save me a good deal of time.
I hope I have explained it clearly enough. I cannot send the file
because it is propriety information.
Thank you,
MikeB
On May 12, 5:17 am, Dave Bonallack
Hi,
What do you want to achieve by sorting?
Dave.
Date: Thu, 13 May 2010 11:01:13 -0700
Subject: $$Excel-Macros$$ Sort data in two nonidentical columns
From: eller.n...@gmail.com
To: excel-macros@googlegroups.com
We have an Excel list with 3 columns. In the first column is the
client
Hi,
If somebody needs some study material and ebooks, then he should probably not
break copyright laws to obtain them. There's lots of non-copyrighted material
available on the net. But if you want a copyrighted publication, then it should
really be bought. The authors write these for their
Hi Ahmed,
I've taken a look at your file, and after a little consideration, I think it
would be best done with VBA rather than worksheet functions. You ok with that?
Regards - Dave.
Date: Sat, 22 May 2010 17:04:52 +0300
Subject: $$Excel-Macros$$ Required Formula
From: ahmedhon...@gmail.com
Hi,
VBA code for yesterday's date is:
A = Date - 1
The variable 'A' will contain yesterday's date.
Regards - Dave
Date: Tue, 25 May 2010 12:08:06 +0530
Subject: $$Excel-Macros$$ Excel macro Help : Date of Previous day
From: nsund...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Hi Michael,If you want to stop people copying your algorithms, then Excel is
not the platform to use. Its security is about as good as wet tissue paper;
Excel 2007 being slightly better, as good as dry tissue paper.The advantage of
using Excel is that you can design a workbook that meets very
Hi,Too little information to answer your question properly, but maybe you an
make use of the attached.Regards from Brasil - Dave.
From: nandkumar.hindust...@gmail.com
Date: Mon, 14 Jun 2010 10:21:42 +0530
Subject: $$Excel-Macros$$ Insurance Calculation sheet
To: excel-macros@googlegroups.com
Bawazir
Thanks
On Mon, Jun 14, 2010 at 9:59 PM, Dave Bonallack davebonall...@hotmail.com
wrote:
Hi,
Too little information to answer your question properly, but maybe you an make
use of the attached.
Regards from Brasil - Dave.
From: nandkumar.hindust...@gmail.com
Date: Mon, 14 Jun 2010 10:21
happy:-) Thank you so much for the help!
I also wanted to thank Alvin and the others who have also provided
suggestions and solutions. What a great group!
Thanks, again,
Kristin
On Jun 17, 4:03 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Kristan,Have a look
working with it to see.
Kristin
On Jun 17, 4:03 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Kristan,Have a look at the attached. It's a stripped down and modified
version of a sheet I designed a while ago. Perhaps it will suit your
purpose.Note that there are more named ranges
Hi,The formula give below is excellent, but assumes that the 97 will always be
subtracted just twice. I've made modifications which allow the 97 to be
subtracted up to 7 times, which more than covers all the possibilities.Regards
- Dave.
From: flnle...@gmail.com
Date: Sat, 19 Jun 2010
Hi Regina,
The problem seems to be that XL has dropped off the leading zeros, so sometimes
your data is 6 characters long, and sometimes just 5.
When the data is 6 characters long, you need MID(E2,1,4)
But when the data is only 5 characters long, you need MID(E2,1,3)
(Since you aren't using
No, I think he wants the formatting present in Cell A3, but I don't think it
can be done within a formula.Dave.
Date: Wed, 23 Jun 2010 21:28:14 +0530
Subject: Re: $$Excel-Macros$$ PLS HELP
From: cs4...@gmail.com
To: excel-macros@googlegroups.com
Dear Darmesh,
Please elaborate i think you want
Hi Anton,
XL can almost do what you want, which may be sufficient for you.
If you want to be able to enter your grocery expenditure always in the same
cell, XL can accumulate those entries in another cell using VBA.
For example, You may enter your grocery expenditure always into A2, but the
be sufficient. Your
suggestion that XL can monitor changes to A2 and store the cumulative
total in A3 would be great. I would have about 50 similar accounts
such as gas, books, donations, repairs etc.
Would you be able to construct this macro?
Best Regards,
anton
On Jun 24, 1:49 am, Dave
on the same cell so i can
enter a series of grocery expenses without moving the cursor up one
cell each time?
On Jun 24, 9:54 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Anton,Attached is a sheet with very simple code. Enter a value into a
cell in Column B, and you will see
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your
Hi Ahmed, Dilip,
The problem is that the passport data in Col E of the 'Raw Data' sheet, is
text, which isn't processed properly by SUMPRODUCT.
The formulas in columns C:F are ok because they deal with numeric data, but the
formulas in Column G will have to be replaced with something else,
Hi Dilip,
Sorry, didn't see your latest solution. Excellent!
Regards - Dave
Date: Tue, 29 Jun 2010 15:21:56 +0530
Subject: $$Excel-Macros$$ Re: Required Formula
From: dilipan...@gmail.com
To: ahmedhon...@gmail.com
CC: excel-macros@googlegroups.com
Hi Ahmed,
As promised, please find
=Right(A1,LEN(A1)-8)
Regards - Dave.
Date: Fri, 2 Jul 2010 09:40:24 +0530
Subject: Re: $$Excel-Macros$$ Trim first 8 characters off a cell
From: kumar.bemlmum...@gmail.com
To: excel-macros@googlegroups.com
You can use Mid formulae. By the way you are
On Mon, Jun 28, 2010 at 10:25 PM,
Hi Praveen,
It's a bit long-winded, but here's a formula to find the position of the last
space in Cell A1:
=FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,
,
Regards - Dave.
Date: Fri, 2 Jul 2010 19:48:01 +0530
Subject: $$Excel-Macros$$ Fwd:
From:
Hi,
I don't think you can say For i = 1 to i since i is undefined.
Regards - Dave
Date: Fri, 2 Jul 2010 11:52:06 -0700
Subject: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing
From: bpascal...@gmail.com
To: excel-macros@googlegroups.com
Hi,
Could you please tell me why
Hi,
=LEFT(C2,FIND( ,C2)+2,99
This is incorrect. It's missing a closing bracket, and the ,99 is wrong.
What are you trying to acheive?
Regards - Dave.
Date: Fri, 2 Jul 2010 20:00:54 -0700
Subject: $$Excel-Macros$$ Entering Formulas
From: jazz...@shaw.ca
To:
Hi,
A1 = United States of America
=FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,
,
Firstly, we need to find out how many spaces there are in the text. We do this
by finding the text length of the original text, Len(TRIM(A1)) then the text
length of the text with
, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
I don't think you can say For i = 1 to i since i is undefined.
Regards - Dave
Date: Fri, 2 Jul 2010 11:52:06 -0700
Subject: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing
From: bpascal...@gmail.com
Hi,
If original date is in A1:
=EOMONTH(A1,-6)
Regards - Dave.
Date: Wed, 7 Jul 2010 16:36:18 +0530
Subject: $$Excel-Macros$$ Query - How To Find out Month
From: nikhil201...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date :
Hi,
You can't change the format of data validation drop-down menus.
The option is to use a combo box from the forms or control toolbox menus
Regards - Dave.
Date: Wed, 7 Jul 2010 22:47:28 +0530
Subject: $$Excel-Macros$$ Increase the Text Size in drop-down
From: nikhil201...@gmail.com
To:
a combo box? I'd be interested in
learning more about it. Thanks.
Nadine
From: Dave Bonallack davebonall...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wed, July 7, 2010 7:43:28 PM
Subject: RE: $$Excel-Macros$$ Increase the Text Size in drop-down
Hi,
You
Hi Srinivas,
Sample workbook please.
Regards - Dave.
Date: Fri, 9 Jul 2010 15:11:12 +0530
Subject: Re: $$Excel-Macros$$ Need code for Sort Sub-totals
From: rsrinivasu...@gmail.com
To: excel-macros@googlegroups.com
Hi all,
Can anyone please provide me an update on the below query at the
Hi Prashant,
Please give an example of the converted cells
Regards - Dave.
Date: Fri, 9 Jul 2010 18:06:07 +0530
Subject: $$Excel-Macros$$ Want to convert on Text in each cell to rows
From: prashant...@gmail.com
To: excel-macros@googlegroups.com
Hi all
I want to convert on Text in each
Hi,
I've modified your macro below. The red text is old, to be deleted.
The green text is the new bits.
I've used For Each / Next to loop through each cell in the UsedRange, and Like
rather than Find
I can't test it properly without your workbook, so you'll have to do that and
let me know
Hi,
The attached contains a basic event macro. Change any cell in the range A1:A4
to change the rectangle's size and position.
You may be able to adapt it for your own needs.
Regards - Dave.
Date: Mon, 12 Jul 2010 12:43:39 -0700
Subject: $$Excel-Macros$$ Using Excel to Control Shapes
Hi,
Two things I can think of.
1. In the VBA editor, you will see an Edit menu, in which is a Find option.
Enter BranchLine into that and see if it finds something you've missed.
2. Put a message box just before the first mention you can find of BranchLine:
Msgbox = BranchLine
and see what
On Thu, Jul 15, 2010 at 9:53 PM, Vijay Aggarwal vjaggarwal2...@gmail.com
wrote:
Hi Dave,
It's really amazing!!!
How could u do this??
regards,
Vijay
On Tue, Jul 13, 2010 at 4:54 AM, Dave Bonallack davebonall...@hotmail.com
wrote:
Hi,
The attached contains a basic event macro. Change any
Hi,
I sent a reply to this email a while ago. But when I went to resend it today, I
found some errors which are now fixed. I also removed some lines of code which
weren't necessary.
I've modified your macro below.
I've used For Each / Next to loop through each cell in the UsedRange, and Like
...
This opens a new angle of experimenting with Excel for me...
Cheers!!
Andy
On Thu, Jul 15, 2010 at 9:53 PM, Vijay Aggarwal
vjaggarwal2...@gmail.comwrote:
Hi Dave,
It's really amazing!!!
How could u do this??
regards,
Vijay
On Tue, Jul 13, 2010 at 4:54 AM, Dave Bonallack
.
With Thanks,
Noorain Ansari
On Fri, Jul 16, 2010 at 8:34 AM, Dave Bonallack davebonall...@hotmail.com
wrote:
Thanks Anish.
Dave.
Date: Thu, 15 Jul 2010 18:24:24 +
From: anish@gmail.com
Subject: RE: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A
Workbook
To: excel
and went to Quick
watch, which told me the value was Empty.
On Jul 15, 5:33 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Two things I can think of.
1. In the VBA editor, you will see an Edit menu, in which is a Find option.
Enter BranchLine into that and see if it finds
You're welcome.
Regards - Dave.
Date: Sun, 18 Jul 2010 13:22:42 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Index match with 3 criteria
To: excel-macros@googlegroups.com
Thank you. This worked! WooHoo!
From: Dave Bonallack davebonall...@hotmail.com
Hi Vinrod,
Kind of you to say so, but really really not interested (and certainly not
qualified).
Regards - Dave.
From: nvino...@gmail.com
Date: Mon, 19 Jul 2010 14:21:12 +0530
Subject: $$Excel-Macros$$ Microsoft Most Valuable Professional (MVP)
To: excel-macros@googlegroups.com
Hi Team,
Hi Nadine,
Sample workbook please.
Regards - Dave.
Date: Mon, 19 Jul 2010 16:43:59 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Need SUMIF with 3 criteria
To: excel-macros@googlegroups.com
I need to sum a column if three other columns in one sheet match the three in
, Dilip, Ankur and Dave for Microsoft MVP...
http://mvp.support.microsoft.com/gp/mvpnominate
--
Thanks and Regards
Vinod N more...
Dave Bonallack davebonall...@hotmail.com Jul 20 07:20AM +0800 ^
Hi Vinrod,
Kind of you to say so, but really really not interested (and certainly
Hi Deepak,
Not quite sure what's wrong, but some of the data in Col C has a double //
between the year and month. Also, it's coming up on my system as Month, Day,
Year, which means XL doesn't recognise it as a Date. (If it did, it would
display it according my local settings, Day, Month,
Hi,
10 things you should know about binary . . .
(Welcome to the world of base 2)
Regards - Dave.
Date: Tue, 20 Jul 2010 05:26:21 -0700
Subject: $$Excel-Macros$$ Reverse of rounding
From: laurence.tha...@navy.mil
To: excel-macros@googlegroups.com
I have a macro where I copy data
Hi,
Sample workbook please.
Regards - Dave.
Date: Mon, 19 Jul 2010 16:43:59 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Need SUMIF with 3 criteria
To: excel-macros@googlegroups.com
I need to sum a column if three other columns in one sheet match the three in
another.
Hi Edgar,
You are searching forwhich is a zero-length string.
Perhaps it should be which is a space.
Regards - Dave.
Date: Wed, 21 Jul 2010 14:48:01 -0700
Subject: $$Excel-Macros$$ how do you identify the first space within a series
of words within a a text
From:
Hi,
Have a look at the attached.
The macro prevents the selection of multiple cells.
If the selected cell contains data, it will be locked.
If the selected cell is blank, it will be unlocked.
Once a blank cell is edited, it will be locked automatically.
The protection is not password
You're welcome.Dave.
From: vidyutm...@gmail.com
Date: Thu, 22 Jul 2010 17:42:58 +0530
Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
To: excel-macros@googlegroups.com
Thank you so much sir Dave Bonallack. Its what i was looking for. Thanks
again
On Thu, Jul 22, 2010
Hi,Create a new sheet. On that, in large font, enter Macros must be enabled to
use this workbook.Create a workbook close event macro that makes all sheets
xlveryhidden except the new sheet.Create a workbook open event macro that hides
the new sheet and unhides all the others.If the macros are
Hi,
When I tried it in XL2003, the macro recorder gave:
ActiveSheet.Shapes.AddLine(431.25, 188.25, 678#, 423.75).Select
Try pasting that into xl2007 and see what you get.
Regards - Dave.
Date: Thu, 22 Jul 2010 09:07:29 -0700
Subject: $$Excel-Macros$$ Inserting a Vertical
Hi
This can't be done with worksheet functions without the use of another column,
because of circular referencing.
However, it can be done with macros, either automatically, or by button click.
So, which would you prefer: Worksheet functions with extra column, or VBA?
Regards - Dave.
Hi Mohamed,
Have a look at the attached to see if it does what you need.
Regards - Dave.
Date: Fri, 23 Jul 2010 23:15:50 +0400
Subject: $$Excel-Macros$$ need date functin
From: idhrees...@gmail.com
To: excel-macros@googlegroups.com
Hi team,
I'm using excell sheet in that i have two
Hi,
Not quite sure if I fully understand your needs, but have a look at the
attached and let me know if it suites or not.
Regards - Dave.
Date: Mon, 26 Jul 2010 10:26:56 -0700
Subject: $$Excel-Macros$$ Making sheet references dynamic
From: ejax...@gmail.com
To:
Hi,
I haven't tested this, but it's probably:
Cells(i, 14) = =sum(RC[- x 1]:RC[- y 9])
Regards - Dave.
Date: Mon, 26 Jul 2010 20:09:45 -0700
Subject: $$Excel-Macros$$ using variables as part of a sum function?
From: carlo.bitu...@gmail.com
To: excel-macros@googlegroups.com
Hi,
Have a look at the attached to see if it does what you need.
If you have 170,000 rows, that means 170,000 formulas, which may take a while
for XL to calculate.
Regards - Dave.
Date: Mon, 26 Jul 2010 22:29:05 -0700
Subject: $$Excel-Macros$$ trouble with multiple formulas
From:
Hi,
The cells in currency format will most likely be numeric. So if your data
starts in cell A2, place the following formula in B2, then copy down:
=If(ISNUMBER(A2)=TRUE,A2,)
Regards - Dave.
Date: Tue, 27 Jul 2010 09:42:17 -0700
Subject: $$Excel-Macros$$ Remove selected
you said, but it's worth it.
Kind Regards,
Narelle
On Jul 27, 6:55 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Have a look at the attached to see if it does what you need.
If you have 170,000 rows, that means 170,000 formulas, which may take a
while for XL to calculate
Hi,
=CODE(MID(A2,3,1))
Where cell A2 has your data, and you want to examine the 3rd character.
Regards - Dave.
Date: Wed, 28 Jul 2010 10:48:35 -0700
Subject: $$Excel-Macros$$ How to see the ascii code of a text withing a field
From: gals...@aol.com
To: excel-macros@googlegroups.com
Hi,
My guess is that PROCV is a formula saved by that name.
Check out: Insert | Name | Define
Regards - Dave.
Date: Wed, 28 Jul 2010 16:41:04 -0700
Subject: $$Excel-Macros$$ Re: dont understand sintax...newbie!
From: dlanm...@att.net
To: excel-macros@googlegroups.com
Hi,
I have
Hi,
Try this line of code:
Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select
Regards - Dave.
Date: Thu, 29 Jul 2010 05:27:59 -0700
Subject: $$Excel-Macros$$ create macro to find first empty row
From: federico.mazz...@ikea.com
To: excel-macros@googlegroups.com
.
Nadine
From: Dave Bonallack davebonall...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Sat, July 17, 2010 1:07:56 AM
Subject: RE: $$Excel-Macros$$ Index match with 3 criteria
Hi Nadine,
Have a look at the attached to see if it does what you need.
I've used
No Problem.
Dave.
Date: Thu, 29 Jul 2010 16:41:18 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Index match with 3 criteria
To: excel-macros@googlegroups.com
Thank you so much. I just couldn't see it. I hate when that happens.
From: Dave Bonallack davebonall
On 30 Lug, 01:24, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Try this line of code:
Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select
Regards - Dave.
Date: Thu, 29 Jul 2010 05:27:59 -0700
Subject: $$Excel-Macros$$ create macro to find first
Hi,
When I use SUM on a range of cells that may or may not be numeric, I don't get
a value error. Blank cells seem to be treated as zeros, and text cells are
ignored. I use xl2003. But perhaps I'm not understanding correctly. Could you
attach a sample workbook?
Regards - Dave
Date: Sat,
Hi Nadine,
If I am understanding you correctly, I'd use SUMPRODUCT.
If your data is in Columns A, B, C, then put this in D and copy down.
=SUMPRODUCT(--($A$2:$A$100=A2)*($B$2:$B$100=B2)*($C$2:$C$100=C2))
Any cell in Column D greater than 1 will indicat a duplicate in Columns A, B, C.
The
I forgot to say that the drop-down is in C1
Regards - Dave.
Date: Sun, 1 Aug 2010 01:36:25 -0700
Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
From: simon_mc_webs...@yahoo.co.uk
To: excel-macros@googlegroups.com
Good Evening Gurus,
I have a quick question
You're welcome
Dave.
Date: Sun, 1 Aug 2010 10:24:21 -0700
Subject: Re: $$Excel-Macros$$ Question re: cell comments and validated lists
From: simon_mc_webs...@yahoo.co.uk
To: excel-macros@googlegroups.com
That's it exactly! Many thanks Dave,
Sid.
On 1 Aug, 13:32, Dave Bonallack
Hi Nadine,
Have a look at the attached.
It's a bit long-winded, but seems to work ok.
Regards - Dave.
Date: Sun, 1 Aug 2010 08:23:35 -0700
From: n8dine4ma...@yahoo.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
I have information in the first three cells of a
201 - 300 of 444 matches
Mail list logo