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 comp
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
> 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 a
<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 o
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
> 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, Apri
uest and better 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: $$E
ffer, will be greatly appreciated. If I need
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:
Right(f.Name, 4) = ".tif" Then
>
> Download Free Excel
> Addin<http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html>
>
>
>
>
>
> On Tue, Feb 21, 2012 at 8:37 PM, Dave wrote:
> > Thanks Don I tried it and its giving me a Syntax error.
s
>
> If Right(f.Name, 4) = ".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 V
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.
P
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 process
Guillett
> 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, 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 acci
gt; To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Calculate End of the Month and than lock in
> > that date in a cell
>
> > This should be easily doable. If desired, send forward this msg to
> > dguillett1 @gmail.com and attach your file.
>
> > Don
Thanks brilliant!!
On Nov 7, 12:31 pm, "dguillett1" wrote:
> This should be easily doable. If desired, send forward this msg to
> dguillett1 @gmail.com and attach your file.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original
e: $$Excel-Macros$$ Calculate End of the Month and than lock in
> > that date in a cell
>
> > This should be easily doable. If desired, send forward this msg to
> > dguillett1 @gmail.com and attach your file.
>
> > Don Guillett
> > SalesAid Software
> > dgu
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
can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
>
> From: Dave
> To: MS EXCEL AND VBA MACROS
> Sent: Tue, November 1,
amp; " " & Format(fDate, "mm-dd-") & " " & f.Name
> > End If
> > Next
> > MsgBox msg & Chr(13) & Chr(13) & msg2
> > End If
> > End Sub
>
> > If you don't like
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.
& " " & f.Name
> End If
> Next
> MsgBox msg & Chr(13) & Chr(13) & msg2
> End If
> End Sub
>
> If you don't like the Message box "reporting" results, simply comment it out.
>
> If you insist on
fort.
On Nov 1, 2:56 am, ashish koul wrote:
> Hi Dave,
>
> try the attachment
>
>
>
>
>
> On Tue, Nov 1, 2011 at 1:00 AM, Dave wrote:
> > Hi,
>
> > I need help with the following task. Thanks in advance
> > I am using MS Excel 2010.
>
> > I
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
ns? Would 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
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
above asks:
Is A5 greater or equal to T5? - 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
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@google
gt;"Yes"))
This works, but requires 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 (contagio
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 on
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 wrote:
> Hi All,
> I would appreciate
r
sample, then the formula could be further reduced to:
=MID(A2,MIN(SEARCH({1,3},A2&13)),11)
Regards - Dave.
From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Date: Tue, 5 Jul 2011 14:24:00 +0530
U
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutoria
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 :
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 y
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 extractin
x to return 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/exceldaily
You can also format the cell
Regards - Dave
On 09/05/2011, at 9:17 AM, "STDEV(i)" 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 not &qu
Hi Pravin,
You could try using the INDIRECT function
VLOOKUP(H17,INDIRECT("[SC231WK"&A1&"34.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
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
Rega
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," Date: Tue, 3 May 2011 05:47:53 -0700
> Subject: $$Excel-Macros$$ SUMIFS
> From: gmccaff...@acutus.co.uk
> To: excel-macros@googlegroups.com
>
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. Exactl
formula: eg:
=COUNTIFS(DB_Sheet!$D1:$D30,$A16,DB_Sheet!$E1:$E30,K$2,DB_Sheet!$B1:$B30,$A$74)
This MAY reduce the time significantly.
Regards - Dave.
Date: Sun, 24 Apr 2011 09:03:05 +0530
Subject: Re: $$Excel-Macros$$ Help me in this
From: yashr...@gmail.com
To: excel-macros
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
ut I still think VBA could do each sheet in seconds, not hours.
Regards - Dave.
Date: Sat, 23 Apr 2011 09:07:55 +0530
Subject: $$Excel-Macros$$ Help me in this
From: yashr...@gmail.com
To: excel-macros@googlegroups.com
Hi Experts,
Actually, this waterfall made by me but its take 3hour to complete. Pl
r way to do the same thing.
Regards - Dave
On 14/04/2011, at 10:37 AM, "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 insta
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 t
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
m
legroups.com
Subject: Re: $$Excel-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
wrote:
In the sumif function shown below, I'm referencing a date:
,"=04/25/2011"
=SUMIF($F$5:$BM$5,
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.tcpClient.C
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,"")
=SUBSTITU
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. Follo
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
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 = \\codebase1
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
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
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
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:
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-
Fro
gards - 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.
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
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
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 s
that number to the LEFT function as applied to A1, but have to
subtract 1 to prevent the inclusion 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
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...@h
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 str
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
>
> Pleas
the Tools / 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 intere
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
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
You're welcome.
Regards - Dave.
CC: excel-macros@googlegroups.com
From: karlaha...@hotmail.com
Subject: Re: $$Excel-Macros$$ Need a Macro
Date: Fri, 11 Mar 2011 19:19:00 -0800
To: excel-macros@googlegroups.com
This worked perfectly! Thank you!
Sent from my iPhone
On Mar 10, 2011, at
2:END!A1)
All sheets 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:
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
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
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@googl
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
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
pport.
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 T
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: R
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,
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
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
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 fol
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
--
--
" variable not defined" messages .
I have the macro running through now but Its not importing any
records? I am not getting any error messages can you please shed some
light on why its not working?
Please look at the the thread above for details,
Thanks so much for any help!!
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
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
> Msg
t 11:14 PM, Diamond Dave
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 ma
What is the easiest?
Paul
____
From: Diamond Dave
To: MS EXCEL AND VBA MACROS
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 or numeric
: 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
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 wrote:
> Piece of cake...
> I can probably write it in 20 m
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@go
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:/
uld live 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
>
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.co
knowledge.
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 Sh
(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:0
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
make sense of it. If you have time, 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
1 - 100 of 644 matches
Mail list logo
