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 Wo
*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 Sursh,*
You have to be TRICKY with excel.
What I have done is explained below:- (Pls note that it may not be
the standard approach, as I hv learned Excel and computers on my own and
never went to any Institute.)
First create the command button, then create a test box on it. Format the
text b
*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 wrote:
> Hi Dilip,
>
> I tried
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. Highl
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 happennin
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)
Act
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
>
> I am trying to sort special numbers in a long list of telephone
> numbers (7 digits). For example:
>
> a. Highlight yellow those numbers which have 3 consec
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) Ital
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 wrote:
> I have 2 vba modules that are both within a protected project. I wish
> to remove one mo
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 solved.
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
>
> Team,
>
> Is there a VBA or Fx that w
Hello Everyone,
We are launching a weekly "BEST EXCEL TIP AWARD" from today onwards in the
group. Any member can submit a tip in the weekly contest and win recognition
and Prizes.
This is how we are just one step away from unlocking a vast treasure chest
of Excel spreadsheet tips, tricks, shortcut
Hello Everyone,
Please submit your tip in this post for Week # 24. I am looking for
your overwhelming response in this competition.You just need to submit
your name along with the tip and subject. The tip can be shortcut,
trick, hidden secret, etc.
Last Submission Date-13th June 2009.
Wi
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!
Regar
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
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" co
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 t
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
3.
Hello. First post here (and first post to a Google group). I have
been a long time user of the Ozgrid forum, but I am against the idea
of paying to post. Hopefully I'll find some nice and helpful people
here. :)
Ok, so the find method works on visible and hidden rows depending if
you use LookI
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 will
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 ne
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 given
this is possible if you want to use macro... i hope you can develop
one, but if not let me know...
On Jun 6, 2:29 am, Anon Ymous
wrote:
> Hello. First post here (and first post to a Google group). I have
> been a long time user of the Ozgrid forum, but I am against the idea
> of paying to post
Try this
Worksheets("FCHC-Form").PageSetup.LeftFooter = _
"&""Arial,Regular""&8" & "Examiner: " & Range("U3").Value
Worksheets("FCHC-Form").PageSetup.CenterFooter = _
"&""Arial,Regular""&8" & "Examination Date: " & Range("D6").Value
Worksheets("FCHC-Form").PageSetup.RightFoote
29 matches
Mail list logo