Hi all,
Thanks for reply.it still doesn't work for me.
Dilip I wrote following formula in Workbook_BeforeSave()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
after writing these formula in
*Dear Suresh,*
I have checked it by creating a macro in the attached workbook. It is
working fine. Please go through it once again.
Note:- Macro name is Suresh which is assigned to the button.
Note:- You might move your cursor to the upper area of the button, to see
the help message pop-up.
Dear Suresh,
Please find the solution attached in this email reply.
I have given the explanation(s) in the attached workbook itself.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Jun 4, 2009
*Hi Suresh,*
Please send me your sheet and I will workout this for you. Thanks.
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jun 5, 2009 at 2:55 PM, suresh k brave.sur...@gmail.com wrote:
Hi Lion123,
Have a look at the attached. I've used random numbers to test it.
Details on the sheet.
Hope this is sort of what you want.
Anyway, really interesting.
Regards - Dave.
I am trying to sort special numbers in a long list of telephone
numbers (7 digits). For example:
a.
Hi Harish,
What I am thinking on this that you are putting all of the execution work
on the event of closing of the workbook. Keeping this thing in mind, can
you try and look forward to move some of the execution(s) before closing of
the workbook. Might be like change of some values or
Hi Karthik,
'Try the following code:-
Sub karthik()
Dim a, b As String
Range(a65536).Select
Selection.End(xlUp).Select
b = ActiveCell.Address
Range(a1).EntireColumn.Select
While ActiveCell.Address b
If ActiveCell.Value = Then
a = ActiveCell.Address
MsgBox (next blank cell is a)
see atached file... I've created a name for the formula on column B and used
it in the conditional format condition.
2009/6/5 Lion123 asadnave...@gmail.com
I am trying to sort special numbers in a long list of telephone
numbers (7 digits). For example:
a. Highlight yellow those numbers
Can we apply following feature in a cell in Excel ?:
Typing in a letter in cell should pick up the dropdown item (from
down list ) that matches
the letter
let me consider an example to explain this :
suppose that drop down list contains following items:
1) America
2) India
3) Sri Lanka
4) Italy
I suppose you could add code to module 1 to unprotect the project it's
in, then reprotect itself once you've removed module 2. Would this be
suitable for your needs?
On Jun 4, 8:08 pm, mikeallen7 mikealle...@gmail.com wrote:
I have 2 vba modules that are both within a protected project. I
The problem was the cell format because time needs to be given as a
decimal (devide mins by 60) (+ round to 2 decimal points) and to do
that type the following:-
=[hourly rate cell reference] * (HOUR([Time Paid cell reference])+ROUND
(MINUTE([hourly rate cell reference] /60,2))
Problem
Hi Mike,
I normally like to answer people's questions directly, rather than
offer suggestions, but I'm not sure whether what you're trying to
achieve is possible.
Perhaps an alternative would be to move your proprietary code from
module 2 into a separate xla add-in? That way module 1 can still
I can't understand your issue...
You'll need only to format each cell properly and multiply the hour (HH:mm)
value by 24 hours (Excel converts automatically date and Time to decimal -
besides the display format).
See the attached file.
2009/6/4 Underdog mikebrumb...@googlemail.com
Team,
Is
Hello EveryOne,
I am Aakash from Mumbai.
Tip for the Competition:
Use Control and Key No. '1' i.e Control+1, which is a shortcut for formatting
cells the way u want like formatting font, colour, border, merge cells, wrap
text, text orientation etc.
Try it out.. I often use this!
Name : Samir
Subject : the Great 'F4' - (2)
Tip : The 'F4' is easily the most useful shortcut key in Excel.- (2)
Use F4 to easily switch to absolute reference from relative one and vice
verse.
Example: In B5 type = and then click on cell A1. Excel automatically
writes =A1 in B5. Press F4 to
Hi All,
My tip for the week - Closing all workbooks together without closing
the entire excel
Note: I haven't checked this tip in Excel 2007
click on the file menu (using mouse ) while pressing the shift key.
This will change the Close' command to Close all command.
Click the 'Close all
Hi Fabio,
That's a very interesting approach to the problem, and a very good formula.
Regards - Dave.
From: flnle...@gmail.com
Date: Fri, 5 Jun 2009 09:29:46 -0300
Subject: $$Excel-Macros$$ Re: Phone Number Filtering
To: excel-macros@googlegroups.com
see atached file... I've created a name for
Name : Satti Charvak
Subject : the Great 'F2'
Tip : The 'F2' is easily the most useful shortcut key in Excel, and in
the Microsoft Windows Operatin System (All Versions) of course.
Basically it it helps you rename many things:-
1. File/Folder names in Windows OS
2. Cell text in Excel cells
Hi Everyt one
I am Ruchi
*Tip 4 the competition*
**
F11 is a shortcut for creating chart
if u select the data n press F11 u will get chart on that data
Try it . its good short cut
Regards
Ruchi
--~--~-~--~~~---~--~~
I am, admittedly, a newbie.
I've done some research on my problem, however, and found solutions
for each part... but seemingly not a way to tie them together.
I have an Excel spreadsheet with three worksheets -- Dashboard, Cover
and Form. I want to put a command button on the Dashboard that
Dear All groupmembers,
I am using Tally 9.ERP and one interesting feature in it is that we can copy
data from excel to tally. However when copying from excel I have press F2 and
then select the entire cell and then copy it and paste it into tally. Is there
any shortcut so that everytime I
I am trying to avoid using vlookup for a few reasons I won't go into,
although I'm not sure if this is possible.
I have a table of values in a worksheet, and the values of the table
are defined as p.A, p.B, p.C, E.A, E.B, E.C, etc.
In another worksheet, I would like to pull these values without
Name : Upendra Singh
Subject : Selecting More than one Value in a single Page field for Pivot Table
Tip : There are sometime situation where we need to select more than one
Value form a given Page field in Excel Pivot Table. In Excel 2003, we can
either select “All” or one Value from a
Try this
Worksheets(FCHC-Form).PageSetup.LeftFooter = _
Arial,Regular8 Examiner: Range(U3).Value
Worksheets(FCHC-Form).PageSetup.CenterFooter = _
Arial,Regular8 Examination Date: Range(D6).Value
Worksheets(FCHC-Form).PageSetup.RightFooter = _
Arial,Regular8
24 matches
Mail list logo