Thank you for your advise! I had a solver I desperately needed for
calculations for my project. Thanks to the service you recommended I was
able to unlock it.
пятница, 2 августа 2013 г. в 18:23:52 UTC+4, bigblackc...@gmail.com:
> Has anyone used the service at www.password-find.com ? Our
Thanks for very much, that was just what I was looking for.
Best Regards
Dave
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prabhu Pinky
Sent: Tuesday, October 29, 2013 6:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ data
is appreciated.
Regards
Dave
Visit
http://www.excelvbamacros.com/
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke
menu to do most of the work through macros.
In 2013 the Menu appears as an Add-in with the subitems expandable
beneath it. I woud like to get back to having a bespoke menu but having
the individual macros a add-ins
https://lh6.googleusercontent.com/-L9K0zTBg2rE/UjtYTXMt16I/AEI/-7Q6ckNslx8/s1600/Excel+Menu.jpg
On Thursday, 19 September 2013 16:08:24 UTC+1, Dave Tomlinson wrote:
I have a number of oldish spreadsheets which (in Excel 2003) had a bespoke
menu to do most of the work through
Sorry about the multiple pastes.
In my original message I should have said In Excel 2013 I get the Dad's
Running menu on the add-ins bar. The pull down brings up the sub menu
which I have pasted to the right. This is from another of my spreadsheets
so the captions and Macro names are
If (iFund2Col = GetHeadingColumnNumber(ws, Fund)) 0 Then
... it becomes 0 when I set it to iFund2Col after leaving the function ...
Nope. This is not C. That doesn't set iFund2Col, it tests for equality
with it.
You need to do the assignment in a separate statement.
On Monday, April 29,
respond.
Again thanks so very much looking at the request
Dave
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Don Guillett
Sent: Tuesday, October 02, 2012 3:49 PM
To: excel-macros@googlegroups.com
Cc: 'ashish koul'
Subject: $$Excel-Macros$$ Re: Request
to clarify any of the above, please let me know if I have not provided clarity
to the request. I'm new at this, so I'm not familiar with the correct
terminology.
Regards
Dave
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members
Hi,
I have the following code which searches a folder and than displays
all the .PDF files as hyperlinks in the body of the Excel
spreadhsheet. I want to modify it so that it can display .TIF files
also. Can you please look at the code below and see if this can be
done. All help is appreciated.
) = .pdf ORIf Right(f.Name, 4) = .tif Then
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dave
Sent: Tuesday, February 21, 2012 8:26 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How to modify code to display .PDF .TIF file
types
Addinhttp://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html
On Tue, Feb 21, 2012 at 8:37 PM, Dave davidstev...@gmail.com wrote:
Thanks Don I tried it and its giving me a Syntax error. here is the
line as I have it in the code.
If Right(f.Name, 4) = .pdf OR If Right
I have developed a matrix to capture change over time from one production model
to another, and now I need to upload into a software package with a format as
from
To
Time
WT-628
WT-628
0
WT-628
WT-629
15
WT-628
WT-630
45
(see attached partial example of requested output.
The
Hi,
I have an Excel 2010 Workbook with 17 Worksheets, Sheet1... Sheet17. I
have this workbook shared on the network. Employees open this workbook
and they enter their daily work log into it individual work sheets.
The problem I am having is that No one knows who did it syndrome
where either
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dave
Sent: Thursday, November 10, 2011 2:09 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Modify code to lock multiple sheets in a
spreadsheet.
Hi,
I have an Excel 2010 Workbook with 17 Worksheets
is that lets say when I am done calculating the end of the
month for lets say May than I want that value to remain fixed and not
change when the value in P2 changes next month.
So thanks for all your help
I will try to load a spreadsheet called test.xlsm.
Dave
--
FORUM RULES (925+ members already BANNED
if the files are copied correctly .
3, Then once the copied files are verifiied I want to delete all the
original files from A.
It has to be a copy and not a move operation as my network privelages
get screwed up when I move the files.
Thanks ,
Dave
--
FORUM RULES (925+ members already BANNED
koul koul.ash...@gmail.com wrote:
Hi Dave,
try the attachment
On Tue, Nov 1, 2011 at 1:00 AM, Dave davidstev...@gmail.com wrote:
Hi,
I need help with the following task. Thanks in advance
I am using MS Excel 2010.
I have two folders: A B. I want to do the folllowing tasks
1
,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Dave davidstev...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Tue, November 1, 2011 9:03:43
Here is how I have your script with all the mods you suggested. Its
still not copying the files from October 2011. Move command will not
work as it screws with permissions etc.
When I run the script the Window says Old Files: 10/1/2011 and then it
lists all the files created in September 2011.
can.” - John Wesley
*-
--
*From:* Dave davidstev...@gmail.com
*To:* MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
*Sent:* Tue, November 1, 2011 9:03:43 AM
*Subject:* Re: $$Excel-Macros$$ Copy Files then go
-
From: Dave davidstev...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Tue, November 1, 2011 12:50:11 PM
Subject: Re: $$Excel-Macros$$ Copy Files then go back amd delete them
Here is how I have your script with all
removing the blank rows help?
Any support would be appreciated.
Thanks
Dave
David Pehrson
Materials Manager, Lawn and Garden North America
Walbro Engine Management, LLC
7400 North Oracle, Suite 311
Tucson, AZ 85704
Office (520) 229-5694
Cell (520) 780-1364
Fax (520) 877-3006
Oops
The below should read:
Is A5 less than or equal to T5? - No - Go to the next statement
Is A5 less than or equal to T6? - No - Go to the next statement
Is A5 less than or equal to T7? - Yes - Stop. Answer: S7
Dave.
From: davebonall...@hotmail.com
To: excel-macros@googlegroups.com
? - No - Go to the next statement
Is A5 greater or equal to T6? - No - Go to the next statement
Is A5 greater or equal to T7? - Yes - Stop. Answer: S7
This could probably be easier done with VLOOKUP
Regards - Dave.
Date: Sun, 31 Jul 2011 17:50:12 -0700
Subject: $$Excel-Macros$$ $$Excel-Macro
Hi Haseeb,
I of course haven't seen every answer to every question on this forum, but your
formula solution to finding the number of groups is one of the best I've seen.
Regards - Dave.
Date: Thu, 21 Jul 2011 09:11:12 -0700
From: haseeb.avarak...@gmail.com
To: excel-macros@googlegroups.com
Hi Azeema,
Have a look at the attached to see if it meets your needs. The formula is
really cumbersome, but it's all I can think of at the moment.
Regards - Dave.
From: aze...@gmail.com
Date: Tue, 19 Jul 2011 23:44:14 -1000
Subject: $$Excel-Macros$$ adding adjacent (contagious) cells only
Column U to be left blank, or at least not to contain
any Yes's
Regards - Dave.
Date: Wed, 20 Jul 2011 17:42:59 -0700
From: haseeb.avarak...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ adding adjacent (contagious) cells only
Hello Azeema,
Use this formula
Hi,
Fractions of a month are a bit subjective. Fractions of WHICH month, needs to
be decided. Fractions of a 28-day month? 29- 30- or 31- day month? Or maybe a
standardized 30.4375-day month?
Regards - Dave
On 12/07/2011, at 8:55 PM, Richard richard.m...@gmail.com wrote:
Hi All,
I would
Hi Ashish,
Exactly what I wanted. Didn't know about the .TextFrame part.
Thanks!
Regards - Dave.
Date: Thu, 9 Jun 2011 11:10:06 +0530
Subject: Re: $$Excel-Macros$$ Application.Caller
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
below code will help you in extracting
Hi Sarah,
A way of using worksheet formulas without a lookup table:
If your data is in A2, paste this formula into an adjacent cell:
=ROUNDDOWN(H16*2,-1)/2 - (ROUNDDOWN(H16*2,-1)/2)+4
It's a bit cumbersome, but gives the answer and format you need.
Regards - Dave
Oops. That was supposed to be:
=ROUNDDOWN(A2*2,-1)/2 - (ROUNDDOWN(A2*2,-1)/2)+4
Dave.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
the text within the rectangle. Anyone know the
syntax for this?
Regards - Dave.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
You can also format the cell
Regards - Dave
On 09/05/2011, at 9:17 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
Unfortunately Month Function returns Month Index ( 1 to 12 ) not Month NAME
Assuming A1 containts date data : 12/31/2011
Formula in B1 =MONTH(A1) returns : 12
Hi Pravin,
You could try using the INDIRECT function
VLOOKUP(H17,INDIRECT([SC231WKA134.xls]Sheet1!$I$5:$K$20),H$15,0)
Change the A1 ref to the cell that holds the book number you want
Please note that I haven't tested this. I haven't tried VLOOKUP with INDIRECT
before.
Regards - Dave
Date
Hi,
Without your file, I can't test this, but the XL did accept the following as a
valid formula:
=SUMIFS('1-Diary'!$H$9:$H9954,'1-Diary'!$B$9:$B9954,Today(),'1-Diary'!$J$9:$J9954,HolidayN)
Regards - Dave.
Date: Tue, 3 May 2011 05:47:53 -0700
Subject: $$Excel-Macros$$ SUMIFS
From
Hi,
One way to do it would be:
-Find the last cell in your data (eg A1000)
-Multiply that cell's row number by 2 (eg 2000)
-Paste that cell's data into the cell with the doubled row number (eg A2000)
-Clear that cell (ie A1000)
-Decrement the row by 1 (ie A999)
-Loop to step 2
Regards - Dave
You're welcome.
Regards - Dave
Date: Mon, 25 Apr 2011 17:29:30 -0700
Subject: Re: $$Excel-Macros$$ macro to add fill color to a column of selected
range
From: cje...@yahoo.com
To: excel-macros@googlegroups.com
That's excellent Dave. Exactly what I was looking for.
Thanks
Hi,
Something like:
Dim c as Range
For each c in Selection
If c.Column = 6 then c.Interior.Colorindex = 3
Next c
Note: Colorindex 6 will give you red. Change the number to suit.
Regards - Dave.
Date: Sat, 23 Apr 2011 14:17:08 -0700
Subject: $$Excel-Macros$$ macro to add fill color
the same thing.
Regards - Dave
On 14/04/2011, at 10:37 AM, tomfabtas...@hotmail.com
tomfabtas...@hotmail.com wrote:
Hi,
I run an excel macro on a loop (Excel 2007), which runs for most of
the day and includes copy/paste code. While this macro is running, in
another instance of excel I need to copy
I am using Office 2010. I am trying to search and display PDF files in
a excel spreadsheet.I got the following macro with help from this
group, thanks Ashish Koul.
This macro works great I need to modify it some. I want the macro to
be able to search the directory based on answers prompted from
Hi Jorge,
Your workbook didn't contain any macros.
Regards - Dave
Date: Tue, 5 Apr 2011 23:40:56 +0100
Subject: $$Excel-Macros$$ copy macro error
From: leote.w...@gmail.com
To: excel-macros@googlegroups.com
Hi, can someone please tell what i did wrong, this is my first macro all by
myself
Excellent formula!
Dave.
From: setiyowati.d...@gmail.com
Date: Sat, 26 Mar 2011 16:40:29 +0700
Subject: Re: $$Excel-Macros$$ discussexcel : Macro: Column Number to
Alphabetical reference
To: excel-macros@googlegroups.com
=SUBSTITUTE(ADDRESS(1,A1,4),1,)
=SUBSTITUTE(ADDRESS(1,16384,4
I have VB program that works in Studio 2005.
When I copied same program to Excel, there is compilation error.
Here is a program:
1. Imports System.Net.Sockets
2. Imports System.Text
3. Function Client(Request As String)
4.Dim tcpClient As New System.Net.Sockets.TcpClient()
5.
-Macros$$ Sum If
FOR EXAMPLE CE5 is having date
=SUMIF($F$5:$BM$5,=CE5,$F7:$BM7)
On Sun, Mar 27, 2011 at 6:29 AM, Pehrson, Dave dpehr...@walbro.com
wrote:
In the sumif function shown below, I'm referencing a date:
,=04/25/2011
=SUMIF($F$5:$BM$5,=04/25/2011,$F7:$BM7)
The Date is in cell F5
Hi Akbar,
Have a look at the attached. Type Akbar anywhere on sheet 1
To do the vice-versa thing, enter similar code into the VBA Sheet 3 window.
Regards - Dave.
Date: Thu, 24 Mar 2011 11:36:15 +0500
Subject: $$Excel-Macros$$ How to prevent from duplication in one work book
From: sh.talal.ak
Ashish,
Thanks It works great, can you please make one change for me I want the
macro to start searching from c:\temp\vba always and traverse
sub-directories and not ask the operator any questions.
thanks,
Dave
I changed the ftdpath as below my production files are on a server so have
to put in the address as below, macro runs but does not traverse the sub
directories
Under the pdf directory below I have directories for years and than months
and days. Files are in days folder.
ftdpth =
How do i add Microsoft scripting run time reference to this file?
thnaks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Ok , I added Microsoft Scripting Runtime in the refrence, its #5 in the
Priority list , but the macro is still not picking up sub-directories.
thanks again
--
--
Some important links for excel users:
1.
Hi Susan,
=MEDIAN(IF(F5:F17=1,H5:H17))
This is right, but it's an array formula, so you have to enter it with
Ctrl+Shift+Enter
When you do this, it gives the right answer.
Regards - Dave.
Date: Wed, 23 Mar 2011 14:39:36 -0700
Subject: $$Excel-Macros$$ Median If Formula
From: sunni
Hi Gurus,,
I have the following macro that has been working fine for ages in
Excel 2003 and now is giving me run time error 445 Object doesn't
support this action in Excel 2010. I need help in fixing this macro
please. I have read about the dir method Application.FileSearch
methods but
Thanks, Just a question, I had thought of that, but could not find one
attached to the your spreadsheet. What was I missing. I noticed a
comment about hidden but don't know how that works. Can you provide
any insight?
Thanks Again
Dave
-Original Message-
From: Dilip Pandey
- Dave.
Date: Mon, 21 Mar 2011 14:09:29 -0700
Subject: $$Excel-Macros$$ Need coding help!
From: zhshen...@gmail.com
To: excel-macros@googlegroups.com
Hello-
I have a data set that has lists of names that recorded the person in
position each year. For a study, I need to create a column
I'm new to Excel and VBA. Please point me in right direction.
I have dedicated computer S, where Excel can run macros and retrieve
data from data source. Excel spreadsheet works perfectly on that
computer S.
User have Excel installed on computer C. But computer C unlike
computer S does not have
You're welcome
Dave
From: walpa...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ While Looping, looking for cells that start with
D
Date: Fri, 18 Mar 2011 15:55:08 -0600
Hi Dave,
Thank you for your response. Sounds like your suggestion should work just fine
Hi Santosh,
You have declared number variables as Integer, which have a maximum allowance
of (approx) +/- 32000.
Dim A As Integer
Dim B As Integer
Dim c As Integer
Try declaring them as Long
Dim A As Long
Dim B As Long
Dim c As Long
Regards - Dave.
Date: Sat, 19 Mar 2011 20:22:18
Hi,
If your text is in A1, try this in B1:
=LEFT(A1,SEARCH(~~,SUBSTITUTE(A1,@,~~,LEN(A1)-LEN(SUBSTITUTE(A1,@,-1)
Regards - Dave
Date: Fri, 18 Mar 2011 13:46:12 +0530
Subject: $$Excel-Macros$$ Remove text from a string
From: deepakexce...@gmail.com
To: excel-macros@googlegroups.com
Hi
Hi,
You can use an IF combined with LEFT, something like:
IF Left(A2,1)=D Then (your process code here)
Regards - Dave.
Date: Thu, 17 Mar 2011 11:39:35 -0700
Subject: $$Excel-Macros$$ While Looping, looking for cells that start with D
From: walpa...@hotmail.com
To: excel-macros
of the @
Please let me know if you need the explanation broken down any more.
Regards - Dave.
From: anil.bha...@tatacommunications.com
To: excel-macros@googlegroups.com
Date: Fri, 18 Mar 2011 16:05:23 +0530
Subject: RE: $$Excel-Macros$$ Remove text from a string
Amazing Dave… very well answered
Hi Mrs Rum,
I'd probably just use my Office CD to repair or reinstal XL
Regards - Dave.
Date: Thu, 17 Mar 2011 07:35:33 -0700
Subject: $$Excel-Macros$$ Re: User-defined type not defined - error
From: mrs...@gmail.com
To: excel-macros@googlegroups.com
Please? Anyone? I can't even just
Thanks, I never lost faith, will review in the morning.
Thanks a million for all your support.
Best Regards
Dave
-Original Message-
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Tuesday, March 15, 2011 10:27 PM
To: Pehrson, Dave
Cc: excel-macros@googlegroups.com
Subject: Re
/ Options Menu, Calculation Tab, I've ticked 'Iteration' and
changed the Maximum iterations to 1.
Also, Col B contains Conditional formatting to hide the erroneous dates of
cells that don't have adjacent data in Col A.
Not sure if this any use to you, but it was an interesting exercise.
Regards - Dave
Hi Hemant,
I don't think there's a non-macro solution for this.
Regards - Dave.
From: coolh...@gmail.com
Date: Sun, 13 Mar 2011 23:36:21 +0530
Subject: Re: $$Excel-Macros$$ formula to add date in next column
To: excel-macros@googlegroups.com
Hey STDEV(i),
Thanks a lot but i dont want macro
between (and including) Sheet2 and END will be included, no
matter how many there are.
Hope this helps
Regards - Dave.
Date: Thu, 10 Mar 2011 16:16:37 -0800
Subject: $$Excel-Macros$$ Need a Macro
From: karlaha...@hotmail.com
To: excel-macros@googlegroups.com
I have a tab that totals all
Hi Paul,
Well said. I tried to let it go unchallenged, but since I had nothing better to
do at the time... :)
Dave.
Date: Tue, 8 Mar 2011 19:12:46 +0530
Subject: Re: $$Excel-Macros$$ OT
From: svyas0...@gmail.com
To: excel-macros@googlegroups.com
very nice speech Mr. Paul Sir.
Regards
Hi Paul,
Completely OT, but it has to be jumps, not jumped, otherwise there's no s
in the sentence. -:)
Dave.
Date: Mon, 7 Mar 2011 06:13:04 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ ( ) for Array Must???
To: excel-macros@googlegroups.com
It really depends on how
Dilip,
As I work with this process, I have found a need to sometimes reverse
the process, what would the routine look like to remove / reverse the
process within the same ranges defined.
Thanks again for your support
Dave
-Original Message-
From: Dilip Pandey [mailto:dilipan
Thanks Dilip
Your solution is great, and does exactly what i needed, your support is
so very much appreciated.
Thanks a Million
Dave
-Original Message-
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Wednesday, March 02, 2011 10:17 PM
To: excel-macros@googlegroups.com
Cc
You're the best, thanks again
Dave
-Original Message-
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Wednesday, March 02, 2011 10:22 PM
To: excel-macros@googlegroups.com
Cc: Pehrson, Dave
Subject: Re: FW: $$Excel-Macros$$ Macro to Average a series of numbers
in excel
Dear Dave
.
Dave
From: ashish koul [mailto:koul.ash...@gmail.com]
Sent: Saturday, February 26, 2011 10:45 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Insert row based on criteria
hi dave
Sub newrow()
Dim i As Long
For i = Sheets(1).Range(a1).End(xlDown).Row To 2 Step -1
Hi Ayush,
Perhaps you could play with the word 'Accelerate'
Some suggestions would be:
Excelerated Learning
Excelerated Solutions
Excelerating.com
Exlceleration.com
Excelerate.com
Regards - Dave.
From: jainayus...@gmail.com
Date: Mon, 28 Feb 2011 11:07:31 +0530
Subject: Re: $$Excel
Thank you Rana, for your kind support. Is it possible to accomplish this with a
macro as I hane many rows to deal with?
Thanks
Dave
From: excel-macros@googlegroups.com
To: excel-macros@googlegroups.com
Sent: Sat Feb 26 01:45:23 2011
Subject: Re: $$Excel
How do you insert a sample fine to the inital discussion message?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
I'm also trying it insert a row, but in my example, I want to insert
in after the SubTotal after using the subtotal function adding the
blank row after the subtotal line. How would you modify the macro in
your example to accomplish this?
Dave
On Feb 26, 12:44 am, Mahesh parab mahes...@gmail.com
Team, 1'm looking for support with the SubTotal function in excel
2007 or 2010. I'm looking to insert a blank row between the subtal
line, and the next group. Note: the subtoal line exists in column A.
Any Ideas?
Thanks for your support
--
Expert Team,
I’m struck. What I’m trying to do is create a macro that will average
a series of numbers and replace the numbers in the predefined series
with that average number. Currently I’m assuming two variables. One
macro for a set of 4 numbers, and one set for a series of 5 numbers.
The
Ashish
This works great, thanks for your support and insight. This is just
what I was looking for.
Regards
Dave
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul
Sent: Friday, February 18, 2011 9:43 PM
To: excel-macros
?
Will this macro insert any new data that it does not find in the
montly_totals.xls but finds in the .csv file?
thanks for your help
newby Dave
On Feb 17, 11:15 am, Paul Schreiner schreiner_p...@att.net wrote:
Piece of cake...
I can probably write it in 20 minutes
: original number: wyl-927-TH would read TH, wyl-987 would
be blank, WMF-123-MX would show MX
Any help in sorting out this problem would be appreciated. if there
is a formual that could be incorporated into a macro or just a stand
alone macro either will work for me.
Thanks
Diamond Dave
From: Diamond Dave dpehr...@walbro.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Fri, February 18, 2011 12:44:09 PM
Subject: $$Excel-Macros$$ Special Suffix Identification
I have a series of numbers with the number of characters being
variable and either Alfa
, Diamond Dave dpehr...@walbro.com
wrote:
I have a series of numbers with the number of characters being
variable and either Alfa or numeric, and sometimes characters are
separated with a -, and some ending with -CH, -JP, -MX, -TH, -CC, -
AF.
What I want to do is in the next column, enter a suffix
the macro to do with what it finds?
Regards - Dave.
Sub Whats_In_Range()
Dim rCell As Range
For Each rCell In Selection.Cells
If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then
Range(rCell.Address).Select
Exit Sub
End If
Next rCell
MsgBox Nothing found.
End Sub
Function
Target As Range)
If Target.Count = 1 And Target.HasFormula = True Then Target.Calculate
End Sub
Clicking in any cell will updaye it if it has a formula.
Let me know if I have understood you correctly.
Regards - Dave.
Date: Thu, 17 Feb 2011 12:52:37 +0700
From: squall.l...@gmail.com
in the VBA sheet window:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = $B$39 Then
For Each c In Range(B40:B54)
If c.HasFormula = True Then c.Calculate
Next c
End If
End Sub
Regards - Dave
Date: Thu, 17 Feb 2011 12:52:37 +0700
From: squall.l...@gmail.com
To: excel-macros
.
If there is no match than a new record should be inserted maintaing
the sort order.
Thanks in advance,
Dave
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
I think someone is using my name in vain - unless there are two Dave's in the
world - and I don't know how that could be...
Dave.
Date: Thu, 17 Feb 2011 09:15:24 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Import .csv match records
To: excel-macros@googlegroups.com
.
Regards - Dave.
Date: Tue, 15 Feb 2011 05:00:59 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ A little OT
To: excel-macros@googlegroups.com
The biggest confusion here is the difference between
the Worksheet OBJECT: Sheet1
the Worksheet NAME: Sheet1
and Sheets ARRAY
(Sheets(Sheets.Count).Select)
always select the last sheet in a workbook, even when the last sheet isn't
necessarily the one with the highest sheet number, and also, if the sheet.count
is say, 7, the thing still works if Sheet(7) doesn't exist!
Regards - Dave
Date: Mon, 14 Feb 2011 19:07:28 -0800
, could you please explain
that part?
Regards - Dave.
Date: Fri, 11 Feb 2011 06:15:45 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns
To: excel-macros@googlegroups.com
Curious...
Actually, the Activecell object is not necessary
Hi Paul,
Very helpful and clearly explained, thank-you.
Can we use this, or something similar, to load a range (say A1:A20) into an
array without using a loop?
Sorry, but my knowledge of arrays in VBA is very limited.
Regards - Dave.
Date: Sat, 12 Feb 2011 09:20:50 -0800
From: schreiner_p
Hi,
If you want the same functionality without macros, you'll have to remove all
the buttons and replace them with cells containing hyperlinks. Let us know if
you need assistance with this.
Regards - Dave
Date: Fri, 11 Feb 2011 20:18:55 +0500
Subject: $$Excel-Macros$$ Button programming
Thanks Ashish,
Works great.
Regards - Dave.
Date: Wed, 9 Feb 2011 10:32:26 +0530
Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office
2010 x64
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
try this
On Wed, Feb 9, 2011 at 10:27 AM, ashish koul
Hi Rob,
I am interested in the trapping of a left mouse click, but couldn't understand
it from your posts. Could you please attach a workbook with working code?
Regards - Dave.
Date: Tue, 8 Feb 2011 05:14:53 -0800
Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office
You're welcome,
Regards - Dave
From: rohan.j...@gmail.com
Date: Mon, 7 Feb 2011 10:49:39 +0530
Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
To: excel-macros@googlegroups.com
Hi Dave,
wonderful its a great job
Regards
ROHAN
On Sun, Feb 6, 2011 at 4:40 AM, Dave
, then you'll have to move the whole
block of cells to an unused part of the sheet.
Hope this helps
Regards - Dave.
From: faithful1...@gmail.com
Date: Sat, 5 Feb 2011 08:52:55 +0400
Subject: Fwd: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
To: excel-macros@googlegroups.com
Can someone define
You're welcome.
Dave.
Date: Sat, 5 Feb 2011 20:31:35 +0530
Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
From: rajeshkainikk...@gmail.com
To: excel-macros@googlegroups.com
Hi Dave
Excellent work, I never thought that the conversion can be done by formula.
Regards
Hi,
I think that mm will return 02, while m will return 2
Regards - Dave
From: anil.bha...@tatacommunications.com
To: excel-macros@googlegroups.com
Date: Thu, 3 Feb 2011 14:02:16 +0530
Subject: RE: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA
Hi Aamir,
Please see
Hi,
IFERROR can be stacked, just like IF can be.
Try this formula in C4, then copy down:
=IFERROR(VLOOKUP(B4,$E$3:$F$3,2,0),IFERROR(VLOOKUP(B4,$H$3:$I$3,2,0),VLOOKUP(B4,$K$3:$L$3,2,0)))
Regards - Dave
Date: Tue, 25 Jan 2011 22:57:34 +0500
Subject: $$Excel-Macros$$ Lookup values
Hi Manish,
Please attach the solution you have. Perhaps one of us may be able to speed it
up.
Regards - Dave
Date: Tue, 18 Jan 2011 23:24:56 -0800
Subject: Re: $$Excel-Macros$$ Re: Concatenate Value Problem
From: pansari.man...@gmail.com
To: excel-macros@googlegroups.com
Any Help
1 - 100 of 518 matches
Mail list logo