How are you getting 155,206 columns?
In Excel 2010, there can be only 16,384 columns (and 1,048,576 rows)
So, there must be an issue with where you're coming up with that number.
Paul
On Monday, November 19, 2012 12:47:53 AM UTC-5, Prince wrote:
Hi Group,
i am getting type mismatch
Q: is there any solution for pick the step value in certain table?
I'm sure that there is.
We can easily give you answers.
lots of answers.
The problem is, they may not match up to your question.
I'm not sure what the purpose or intent is for this.
You seem to be highlighting the cell in which
I'm sorry, but that doesn't help much.
Please keep in mind that this collection of data has significance and meaning
to
YOU, but is meaningless to just about everyone else.
how many accounts are profiled
So, somehow these numbers represent accounts.
But I have no idea what you mean by profiled.
The problem is that Excel doesn't really SEE the hours, minutes, and seconds.
What it SEE's is a number.
The date:
Tuesday, November 13, 2012 16:48:41
is actually a number: (41226.700474537) DISPLAYED any way that you'd like it!
This number is the number of days (41226) since 1/1/1900.
The
I'm sorry.. I need clarification.
You said on each of the machines, the D:\ drive is there, same path
So, you're saying that if you sit at ANY of the machines,
you can use Windows Explorer and navigate to the
D:\12-13 folder and the book2.xls file is there, right?
And you can open it?
any place you have .Worksheets(1)
you are SPECIFYING the first worksheet in the workbook!
If you want to import into the currently active sheet
then replace Worksheets(1) with ActiveSheet
when specifying where the data is to be placed.
Or, add your new sheet at the beginning of the file,
which
First of all..
You should consider Forum Rule #1)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
I suppose since the group title is: MS EXCEL AND
You really should use a better subject.
just about everyone who posts here has a code problem
You have not provided any indication either in the subject, or the body
of your post as to what your problem is, or even the area of the problem.
Some people here are EXPERTS in the use of pivot tables.
I cannot test it at this minute,
but can you use:
Application.DisplayAlerts = false
It may be that you have to issue this just prior to issuing the send.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the
Regards
Ankur Aggarwal
Analyst
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Tuesday, 6 November 2012 7:21 PM
Subject: Re: $$Excel-Macros$$ Organization Chart
I also Googled Excel vba Org Chart
and received 189,000 hits
I've modified the subject to provide some meaningful information.
How do you know what parts of the string are important?
I mean, you've started with:
MONEL; 1 1/2 X UNS 1/2 FBECOATED (1/2 CLAD; 1 1/2 CARBON STEEL, 1 1/2 LOW
CARBON STEEL
and have decided that these terms are to be
can,
As long as ever you can.” - John Wesley
-
From: ANKUR AGGARWAL ankur9_aggarwa...@yahoo.co.in
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Cc: Paul Schreiner schreiner_p...@att.net
Sent: Wed, November 7
waste of time of many..
Reagdrs,Bhanu
On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner schreiner_p...@att.net wrote:
Notice Forum Rule #3?
3) Don't post questions regarding breaking or bypassing any security measure.
WE don't have any way of knowing if you own the code or are simply trying
I took a look at your file.
It seems to have something to do with the type of image that was inserted.
I was able to double-click on the image, and a popup was presented allowing the
image to be converted to a Shape collection.
Once I converted it, I recorded a macro in which I changed the
the people you can,
As long as ever you can.” - John Wesley
-
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Tue, November 6, 2012 8:40:43 AM
Subject: Re: $$Excel-Macros$$ Organization Chart
You've asked for the FORMULA,
That implies that you don't want to use VBA, but wish to use Excel formulas.
Let's say that the date you're checking is in A2,
The simple answer is to subtract this year Year(Today())
From the year of the of the date in A2 Year(A2)
giving:
YEAR(TODAY())-YEAR(A2)
The
Sorry, this has nothing to do with deleting alternate sheets.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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.” -
I'm not quite sure what you mean by using find/replace.
I realize you want to replace 1a with 2, but perhaps there's more to it
than
that.
I'm not sure if you're looking for a VBA solution, or a Excel menu solution?
Is the data sorted? or are you intending to perform this replacement to ENABLE
Notice Forum Rule #3?
3) Don't post questions regarding breaking or bypassing any security measure.
WE don't have any way of knowing if you own the code or are simply trying break
into the code to determine some type of proprietary information (hacking)
If you are attempting to perform some
Have you noticed Forum Rule #1?
---
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
You know, I've used DateDIFF in VBA, and I THOUGHT there used to be an Excel
equivalent.
but when I looked in Excel2010, I didn't find it in the function wizard.
Now it looks like it's THERE, but undocumented.
You can find it in ONLINE help, but not in the help file in Excel.
If you have the macro able to run by a button,
check the documentation for the OnTime function.
this should allow you to set it up to run at specific times.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the
I take it you mean delete?
Are you wanting to do this for a specific sheet or all sheets in your workbook?
You can use a Change event macro.
for a single sheet, Worksheet_Change()
for all sheets: Workbook_SheetChange()
in these macros, simply test for the target value = .
If you want a
There really is no way for us to help you with the limited information you've
provided.
Actually, that's not true.
There are LOTS of ways.
hundreds of thousands of ways.
MOST, except for perhaps a hundred or so, are not relevent to your situation.
So, to narrow it down,
We would need to know
I have a couple of solutions for you.
(with lessons along the way)
First, in the Change Event, Target CAN be more than one cell.
For example, if you decide to clear all values in the column,
you'd select the range and hit delete.
Then, Target becomes an ARRAY of cells.
What I like to do is
Doesn't that loop through all cells in all columns AND rows?
Even though that's what he ASKED for, that's probably not what he meant.
I'd use something like:
Sub testvis()
Dim R
For R = 1 To ActiveCell.SpecialCells(xlLastCell).Row
If (Not Cells(R, A).EntireRow.Hidden) Then
@googlegroups.com excel-macros@googlegroups.com
Sent: Fri, November 2, 2012 10:42:22 AM
Subject: Re: $$Excel-Macros$$ execute macro on delate
Paul,
thanks a lot is working as I wanted, it will take me some time to figure it up
how is working, but its so gd.
Thanks
Pawel
From: Paul
The problem is that Cells D263 and D355 have a space in them.
When you try to issue k = k + ,
you get a Type Mismatch because you cannot add a space to an integer
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all
ramaswamy era_...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Fri, November 2, 2012 1:15:24 PM
Subject: $$Excel-Macros$$ Re$$Excel-macro$$vba for sumif function-type mismatch
error -reg
Dear Expert Paul Schreiner,
Thank you for your remarks. After correcting
That's not going to work out well.
Let's say you have 11 sheets
the Sheets() array looks like:
Sheets(1).Name = One
Sheets(2).Name = Two
Sheets(3).Name = Three
Sheets(4).Name = Four
Sheets(5).Name = Five
Sheets(6).Name = Six
Sheets(7).Name = Seven
Sheets(8).Name = Eight
I tried it and it worked fine.
However, I didn't spend the time to create a bunch
of drop-down menus. I just used some data I already had.
Maybe the problem is with copying the selected values of the drop-downs.
perhaps if you posted your file? (or an edited version)
Otherwise, we could spend
the sheets that you choose = This is also possible if
you doesnt wish to use the VBA code.
Let me know if you failed to understand.
Thanks
Ahmed Bawazir
by Clicking by mouse select all the sheets that you wish to delete
On Thu, Nov 1, 2012 at 2:46 PM, Paul Schreiner schreiner_p...@att.net wrote
There are many possibilities, but most depend on your computer system.
Do you (or someone else) regularly back up your folders?
If this is a company computer, does someone else back up the folders where
you stored this file?
If so, then the file can be restored from the last backup.
If not,
The editor used by Puttu
is replacing the quotes with smart quotes
(notice the way the quotes at the beginning and end of
“Send Massange” (sic)
are different?)
Replace them with
also, these macros must reside in a standard module
rather than a sheet module.
Paul
Is the 200 workbooks the ONLY files in the folder C:\EBACKUP ?
If so, you can place this macro in a standard module of your master workbook:
Sub CopyData()
Dim fso, Fldr, fl, fc, f
Dim Sht
Sht = Option Letter
Fldr = C:\EBACKUP\
Application.ScreenUpdating = False
Set fso
What line is producing an error?
I ran it and it worked fine.
But my sheets weren't password protected.
At no point in your macro are you applying the password to unprotect your
sheets or workbook.
Since I don't know what kind of Protection you've issued on your workbook and
sheets,
it's
also
raise the priority class of the Excel process to Above Normal or High.
Asa
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: Friday, October 26, 2012 5:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel 2010
*
Thanks Paul
pls see attached
On Tue, Oct 30, 2012 at 6:56 PM, Paul Schreiner schreiner_p...@att.net wrote:
This message is eligible for Automatic Cleanup! (schreiner_p...@att.net) Add
cleanup rule | More info
What line is producing an error?
I ran it and it worked fine.
But my sheets
Your example seems to imply some assumptions.
Is the value in column 2 ALWAYS longer than the value in column 1?
What if the values are:
ABC1alpha and ABC1beta
what do you want in the third column?
When you said that you want to extract the characters, does that mean
that you want the first
()
ThisWorkbook.Worksheets(Pravin Gunjal).Activate
End Sub
NB: Pravin Gunjal - is the sheet name which should be displayed while opening
the file.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Paul Schreiner schreiner_p...@att.net
Date: Fri, Oct 26, 2012 at 4:45 PM
Subject: Re: $$Excel-Macros
Where did you put the macro?
Event macros have to go in the Sheet modules or the ThisWorkbook module.
This Workbook_Open event macro
belongs in the Thisworkbook module.
If you want to create an Auto_Open macro
it belongs in a standard module.
Then, of course, you must select to enable macros
There are several different types of loops.
The type you select will depend on your specific situation.
a couple of examples would be:
'---
Sub Loop1()
Dim Rng As Range
For Each Rng In Range(A2:A10)
MsgBox Rng.Value
Next Rng
I have macros that run for several minutes (usually updating an Oracle
database)
I update the StatusBar to indicate progress, like:
if (nRec mod 1000 = 0) then Application.Statusbar = Processing nRec
of nRecordCount
I've noticed that after a few cpu cycles, Excel goes into Background.
To change your button caption from No to Submit (and back), use:
ToggleButton1.Caption = Submit
as to WHEN you want to change it,
You can put this in a TextBox1_LostFocus event so that it would change
the button after you've changed the Textbox contents and select outside the
textbox:
24, 2012 at 9:19 PM, Paul Schreiner schreiner_p...@att.net wrote:
YahYa,
Here is a scrubbed version of an application I wrote several years ago.
In this case, individual Attendance is recorded on separate sheets
I used User Names:
Micky Dolenz
Michael Nesmith
Peter Tork
Davy Jones
For each
This looks very similar to the topic you posted called:
Macro Help: Repeat the macro for each cursor move
The same answers apply.
You can create an event macro that clears all highlighting and highlights
the row and/or column of the selected cell.
As for your requirement:
This should be
MYpassword =frm_pwd.Show
won't work.
Think about UserForms for a minute.
you can have numerous text boxes, list boxes, labels and buttons.
When you close the form,
WHAT gets returned to the calling program?
In fact, I don't think the .Show method returns ANYTHING.
You might be able to create a
That's a start... but it doesn't have all of the days of the year.
(you probably noticed that)
Several years ago (10+?) I put together an attendance tracker for my supervisor.
There were separate sheets for each individual in the department,
then a summary sheet that displayed how many people
Are you saying that your VLookup Value occurs in multiple rows in your table?
or that you want to return multiple values from the single match?
Then.. what do you want to do with the results?
Paul
-
“Do all the good you can,
By all the means you can,
In
First of all, this is not the forum for this type of distribution.
Secondly, the information is a hoax
and has been passed around since 2005 with different plants as remedies.
http://www.joewein.net/hoax/hoax-papaya-juice-dengue-fever-cure.htm
Please refrain from posting chain mail messages in
your macro is basically correct:
contents = Worksheets(“Sheet1”).Range(“A1”).Value
however, the 'quotes' in your line are incorrect.
(“) and (”) are improper delimeters.
It should read:
contents = Worksheets(Sheet1).Range(A1).Value
Paul
-
“Do all the
hmm... just to be clear, your statement:
Just remove the inverted commas
is not entirely accurate.
Those are quotes () not commas(,)
and, inverted means up-side-down.
The quotes that were used is what is called curly quotes or book quotes
or techincally called reversed or double prime quotes.
I've usually come across this if the password supplied with
the unprotect method is incorrect.
can you check that?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To
Was the solution I provided insufficient?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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
You explanation is somewhat vague..
By breaking it down into individual definitions:
Repeating the macro implies that you have a macro in mind.. good start.
cursor is a general term referred to the type-in bar, usually a vertical
bar
(|) or underscore (_).
cursor move would then be movement
and click any where in the excel you will find my requirement.
I need this task should be completed by mouse/keyboard move.
ThanksN.Sundarvelan
9600160150
On Wed, Oct 17, 2012 at 5:26 PM, Paul Schreiner schreiner_p...@att.net wrote:
You explanation is somewhat vague..
By breaking it down
:03 PM UTC-4, Paul Schreiner wrote:
How do you want the files named?
Do you want them in a specific folder?
Do you want them left open at the completion of the macro? or close them all?
Paul
-- ---
“Do all the good you can,
By all the means you can,
In all
in the
script itself I believe. If I replace that with my own it should run proper
per
your comments below, no? But again, I can't even thank you enough!
On Tuesday, October 9, 2012 9:03:00 AM UTC-4, Paul Schreiner wrote:
Here you go.
The macros are a little more sloppy than I'd
normally manage
Are you saying that you want each row of data copied to a NEW workbook?
or are you say that you have multiple rows
that you want copied to separate workbooks based on the value in column A for
each row?
either way is easily done.
Paul
-
“Do all the good
for 4010, 4012, etc...I appreciate the help. I
know it's not hard, I'm just limited in terms of my VBA knowledge.
On Monday, October 8, 2012 2:55:49 PM UTC-4, Paul Schreiner wrote:
Are you saying that you want each row of data copied to a NEW workbook?
or are you say that you have multiple rows
Based on the pattern,
it looks like you're wanting to round UP to the next increment of 5
However, there's might be a small problem.
Are the numbers you're testing really %'s?
That is..
is 50.3 really .503 represented as 50.3%
or is it actually 50.3 and you're just CALLING it a %?
If it's
You probably mean BAN
Definitions:
Bane: A source of harm or ruin
Ban: To prohibit (especially by legal means)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To
Are you saying that the folders are IN Outlook?
Not on your filesystem?
(that is like C:\temp\X)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you
Sorry for delay
i have outlook mail save in folder every mail has excel attachment...
i want to extract all excel in onether folder..
Regard
Manoj
On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner schreiner_p...@att.net wrote:
Are you saying that the folders are IN Outlook?
Not on your
for Folder to Folder
now i have a folder in outlook, folder contain many mail, every mail has a
attachment with same name.
i want to save all attachment in my desktop folder with different name..
On Wed, Oct 3, 2012 at 5:54 PM, Paul Schreiner schreiner_p...@att.net wrote:
OK... I'm going
You haven't given us much to go on,
but you could use this vba:
Option Explicit
Sub DupData()
Dim nRows, R, dRow
Dim DupCnt As Integer, dCnt, tDate, tName
Dim dArray, inx
Range(F2:G65000).ClearContents
dRow = 0
nRows =
You need averageif()
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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
I'm not sure I agree.
People... Don't... Read
For the most part, when people sign up, they don't even bother to READ the
rules.
You could EASILY put some jargon in there that basically says that if you
violate the rules, you owe a penalty,
and they'd never even notice.
At least with it on
is there a question here?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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
On Mon, Sep 24, 2012 at 5:23 PM, Paul Schreiner schreiner_p...@att.net wrote:
is there a question here?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all
the differences between xlsx and xlsb is the ability to save macros with
the file.
it has no affect on Excel formulas or functions, unless they're Custom
functions (User Defined Functions)
The differrence between xlsm and xlsb is that xlsb is a binary format,
while .xlsm allows the use of xml.
You cannot do either without a macro.
You have to have at least one sheet visible.
To hide or unhide all sheets you can use:
For sht = 2 to sheets.count
sheets(sht).visible = false '(or true)
next sht
To sort sheets, I would first load the sheet names into an array,
sort the array,
then
it looks like your first macro is irrelevent to your question.
You're wanting repairs to:
Private Sub salarynew()
Dim r As Double
For r = 1 To 20
' Earlier E now should be value of cell I1
' Earlier F now should be value of cell I2
If Cells(r, cells(1,I)) =
Have you tried Conditional formating?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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
Sorry,
I actually wrote this last week, but evidently never posted it!
I noticed that your code example and your sample file and description is
different.
you SAID that if you find a match, you want to replace B with F and D with H
but in your code:
Cells(r1, f) = Cells(r, b)
Cells(r1, h) =
, September 17, 2012 7:13:18 AM
Subject: Re: $$Excel-Macros$$ Check for Repeats in cell
Hi Paul,
Conditional format also works on value of cell not on formula of cell.
I want to work on formula insted.
Rgds//Vabs
On Monday, September 17, 2012 4:33:25 PM UTC+5:30, Paul Schreiner wrote
Back to one of my several earlier questions:
Are the Item Master rate dates regular?
That is: Will there be an entry for a specific item every
week/month/quarter/year??
If so, then we could develop a Dictionary Object and store, say, each Item
Master and the rate for each Quarter.
Then, from
ok.. what have you tried so far?
Are you using filters?
or will the string potentially appear in any column?
in which case you'd want to find the string, and hide the row.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
Is there anything stronger then Banned?
Maybe Flogged and Banned?
I think every person that receives the spam should respond DIRECTLY TO HIM
once for each time you receive it.
I don't mind someone that fails to read the guidelines and sends something
like this ONCE.
But getting five or six of
wow...
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
this is a Doubt?
Doubt: a)to consider unlikely , b) to lack confidence in.
Do you not know the names of your files?
simply add a sheet to your workbook and enter these names.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people
What version of Excel are you using?
In Excel 2010, there is a variation of the WorkDay function called Workday.INTL
WORKDAY.INTL(start_date, days, [weekend], [holidays])
Returns the serial number of the date before or after a specified number of
workdays with custom weekend parameters. Weekend
If you sort the data by Date, in Descending order,
a VLookup will return the first match, which will be the latest date.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you
Can you check to see if it has the Workday.INTL function?
(I don't remember if it was new with 2010, or 2007)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all
So, your Column B and C is a list of unique item/description combinations?
Not sure why you would end up with that, but the formula in D2 would be:
=VLOOKUP(A2,B:C,2,FALSE)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you
Circle Invalid?
Are you refering to a Circular Reference?
I've never heard of a Circle Invalid function.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the
What ???
Have you TRIED to look at the Help for the function?
Simply go to the function Wizard, select BIN2DEC
and hit the Help on this Function link.
It tells us that BIN2DEC :
Converts a binary number to decimal.
If you don't encounter binary numbers, then you'll have no need of this
That's precisely the point!
Because he's wanting to do this with formulas, he's making the solution more
complex than necessary.
A VBA solution would be very neat and tidy (use split to load an array, and
display the array elements in the cells)
A manual solution using text-to-Columns is also
One technique I've used in the past is to use VBA to open a text file in Binary
mode.
With this, you can read the passwords for comparisons.
This password file is then placed on the network and cannot be opened/viewed
by anyone UNLESS THEY WRITE A VBA MACRO.
Of course, you have to protect
I believe that the problem is that, when you enter the formula in the Workbook,
you're entering it as an ARRAY formula, where it matches the value in Column A
and column B is EITHER 12 or 13 ({12,13})
But in your VBA, you're only counting a match of 12:
Sheet2.Cells(i, 2) =
tried Google?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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
You can try:
Option Explicit
Sub Unique_ID()
Dim Dict_Userid
Dim sht, SummarySht
Dim R, nRows, uArray
SummarySht = Sheet5
Set Dict_Userid = CreateObject(Scripting.Dictionary)
Dict_Userid.RemoveAll
'-
Don,
technically...
N.Sundarvelan (the originator) included a file in .xlsx format.
Which implies he has either xl2007 or xl2010...
But.. yes, this solution seems to have LOTS of selections.
and other jumping around that is a lot of wasted motion.
any time the display is updated, the run time is
??
I think what we have here is a failure to communicate
In Excel, to flip a chart means to reverse the Axes.
You don't make a flip chart.
Therefore, I have to assume that you're using an old-school term for the type
of
chart projected for demonstration or teaching purposes.
Which is what
First of all,
Your statement of work and you program is backwards.
You SAID:
... if matched update the value of Col B to Col. F and the value of Col D to
Col H
but your program says:
Cells(r1, f) = Cells(r, b)
Cells(r1, h) = Cells(r, d)
which is setting F to B, not B to F...
just so we're
Did you not like the solution I provided?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you 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
..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Friday, September 07, 2012 11:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent... Please Help... (place useless subject
here)
Is it me? or does
Here's something I threw together from macros I already had.
I didn't spend too much time on it.
I hope they have what you're looking for.
There are several things you MENTIONED that I tried to include.
Since you want the user to view ONLY his performance,
I added filters to the YTD Output sheet
entering the CSE
formula.
Regards,
Sam Mathai Chacko
On Sat, Sep 8, 2012 at 1:38 AM, David Grugeon da...@grugeon.com.au wrote:
The numbers are strings too
=LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#})
)
Regards
David Grugeon
On 8 September 2012 03:57, Paul Schreiner schreiner_p
Zibraan,
As mentioned, you can use a BeforeSave event macro:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets(Sheet1).Range(B1).Value = Now()
End Sub
Paul
-
“Do all the good you can,
By all the means you can,
In
801 - 900 of 1474 matches
Mail list logo