Right click cell, Format Cells, Custom -
#,##0 Dr.;#,##0 Cr.
On Tue, Apr 17, 2012 at 11:56 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
Is there any formula to written in cells format for the positive value
display as 1234 Dr and for negative value display as 1234 Cr ?
Everything for the watch set up exactly as you describe and the watch
window shows exactly what you said below.
But it does not break. Program runs to the end though maxrow only shows
111 even though it goes beyond that.
I will figure it out.
Range.show works great though as you say way faster
Try setting a watch with break when value changes, then keep hitting F5 to
resume execution after checking the current value (assuming it breaks for
you). You may find that the value of maxrow is never set to 111, even if it
eventually surpasses that.. it's either that, I think, or else the
Hi,
Superb links.
Thanks,
Hari
On 14 April 2012 12:44, PRAVESH KUMAR praveshkash...@gmail.com wrote:
Hi Varun,
a lot of Thanks
On Tue, Apr 10, 2012 at 9:13 AM, VARUN CHAWLA varunchawla...@gmail.comwrote:
On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote:
Dear
Watch working now but I did not change anything. Weird. The following
works nicely for the delay though I wonder about a corner case where the
timer started just a fraction before midnight... but I could just break.
On Mon, Apr 16, 2012 at 11:57 PM, Asa Rossoff a...@lovetour.info wrote:
Hi Deba
Asa is spot on with Chandoos site. Gives very basic info wrt Dashboard. What I
would like to also say is that with Dashboard creation, you have a lot of
lookup situations. Index and Match function is you best Friend for this,Choose
function will be your sister.Rows and Columns will be
Don't see the delay code you refer to, but there are solutions. you can do
various math gymnastics to get back out of the corner with Timer(), or for
1-second resolution, use Application.Wait (suspends code execution for x
seconds), or Application.OnTime, or Now()*86400 (for any of these, might
please check the attachment
regards
Sanjib
-- Forwarded message --
From: Ashish Bhalara ashishbhalar...@gmail.com
Date: Tue, Apr 17, 2012 at 11:56 AM
Subject: $$Excel-Macros$$ Format cells for Number
To: excel-macros@googlegroups.com
Dear expert,
Is there any formula to
Oh yeah. You have to actually paste.
.Cells(maxrow, ReverseDate).Show
Dim Start
Start = Timer
Do While Timer Start + 0.03
DoEvents
Loop
On Tue, Apr 17, 2012 at 12:28 AM, Asa Rossoff a...@lovetour.info wrote:
Don't see the delay code you
Actually the way you wrote it is safe.
timer always 86400
start = timer so start 86400
edge case, start=86399.98
then timer becomes 0
do while.. 0 86400.01 etc.
easily true, so loop breaks early.
An elegant solution, thanks to Windows API:
Declare Sub Sleep Lib kernel32 (ByVal
no, this is not a safe hour to determine safety of code. I was thinking Do
Until even as reading Do While.. yours, you're right, has that edge case
issue.
The API should do the trick without adding complexity.
Asa
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Tuesday, April 17,
*Hi Experts,
Can you please create for me please. Please find the attached file, there
is clearly explain which need to be added chart. thanks in advance
*
Thanks Regards,*
*
*Deba Ranjan P***
MIS - Operation
On Tue, Apr 17, 2012 at 12:59 PM, Deba Ranjan drdeva...@gmail.com wrote:
DEAR SIR,
I HAVE TWO SHEETS ONE PROGRESS TRACKING DATA AND REPORT-INDEX I WANT TO
CAPTURE DATA FROM PROGRESS TRAKING DATA SHEET IF COL (I1) OF
REPORT-INDEX MATCHES WITH COL(P) OF PROGRESS TRACKING DATA IT SHOULD
LIST ALL ROWS WHICH MATCHES BUT ONLY THOSE COLUMN WHICH'S HEADING
(COLORED
Hi
Please Use alt + ctrl + L then Ctrl D
On Tue, Apr 17, 2012 at 3:07 PM, muralidhar e emuralidha...@gmail.comwrote:
hi dear group members,
Good afternoon
Iam using excel-2007 2010, with a huge data, with this when iam suppose
to use Ctrl+F for find the batches by overlook when iam
Hi,
Is it possible to lock VBA project of all xls and xlsx files of a folder and
its sub folders.
Thanks
Hiren
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any
hi, anil
Iam not understand, if u not feel can u explain it.
*Iam what i need is simply is.*
iam need not want Ctrl+D option and it disable in my worksheet. if i
suppose to use the Ctrl+D option i need a passward when i am using the
Ctrl+D.
Thanks
Muralidhar E
On Tue, Apr 17, 2012 at 3:11
HI Rajan,
Thanks its working fine, try to help me on ZIP files too.
On 4/16/12, Rajan_Verma rajanverma1...@gmail.com wrote:
Ah,, Got the problem actually I have call Another Function , Now you can
check
Rajan
-Original Message-
From: excel-macros@googlegroups.com
Hi Experts,
Could you please tell me what is shortcut key like excel Ctrl+Shift+:in
OPENOFFICE.
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Dear All,
Can you please let me know the best resource to learn MS SQL queries?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
Hi,
Try it,
Private Sub Workbook_Open()
Application.OnKey ^d,
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey ^d
End Sub
On Tue, Apr 17, 2012 at 3:36 AM, muralidhar e emuralidha...@gmail.comwrote:
hi, anil
Iam not understand, if u not feel can u explain
Hi Amit,
I think ,its sqlcourse.com
Thanks Regards,
Vikash Chandra
Bangalore
9902622922
On Tue, Apr 17, 2012 at 5:34 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear All,
** **
Can you please let me know the best resource to learn MS SQL queries?
** **
Best
Hi Deba
Am currently on .BB () only so you have to go thru this process yourself.
If you want the % of total billing against bal of billing to achieve then
1. In the Dashboard sheet divide cell F8 by cell G8. Give it a label and then
next to it type a 100% and label that also
2. Copy the
Sir , From our HO, we need to send to all CITY cerntre's
offices/branches details pertaining to their specific figures. At
HeadOffice we have total data for the entire system . Here say The
Delhi offices need info pertaining to DELHI CITY/Off./Branches only.
Furhter the item-xxx pertains to
Try this site.. Even you can execute your query on this web no sql server
needed.
http://www.w3schools.com/sql/default.asp
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vikash Chandra
Sent: Apr/Tue/2012 06:23
To:
You did not provide an example but I would suggest you only use ONE sheet and
simply use
datafilterautofilter
to filter the data you want and hide the columns you don’t want to show.
A macro can be used to do this for you
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
I am using filter only but my filter selection is in the header area
only column F row 1,2,3,5 I am using concatenate function to combine
these value in col I1, and this value I want to match with PROGRESS
TRACKING DATA sheet
col P (col16), actually some of the information I want to show only
HI All,
Is thr any other short cut key for COPY Paste (except ctrl c v).Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
Ctrl+insert and Shift+insert
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Apr/Tue/2012 08:35
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Control c v
HI All,
Is thr any other short cut key for COPY Paste
Dear N.Sundarvelan,
I found the following by going to TOOLS-Customize-Keyboard in LibreOffice
(should be similar to OOo):
ctrl-shift-;current time (date and time, formatted to show time)
ctrl-;current date (date and time, formatted to show
date)
ctrl-shift-+
Dear Ashish,
Please select required area and run below macro.
Sub change_format()
For Each Rng In Selection
If Rng.Value 0 And Not (IsEmpty(Rng.Value)) Then
Rng.Value = Rng.Value Dr.
ElseIf Rng.Value 0 And Not (IsEmpty(Rng.Value)) Then
Rng.Value = Abs(Rng.Value) Cr.
End If
Next Rng
End Sub
Dear Sunarvelan,
Please check below link..it is very useful for Open Office Environment.
http://www.openoffice.org/documentation/manuals/oooauthors/index.html
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
Thanks a lot.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: 17 April 2012 19:09
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Best resource to learn MS SQL queries
Try this site.. Even you can
**
On Tue, Apr 17, 2012 at 11:00 PM, kevin pietersen resumeske...@gmail.comwrote:
infotargets.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Must be sending to all contacts. I believe it's some kind of
solicitation--obviously misdirected--but based on info so far (3 of these
emails in 2 days, hasn't responded to list questions about the messages), I
think resumeske...@gmail.com should be banned without further ado.
From:
Thanks a lot friends, I learn many thing regarding shell format from all of
you.
Ashish
On Tue, Apr 17, 2012 at 10:20 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Ashish,
Please select required area and run below macro.
Sub change_format()
For Each Rng In Selection
If Rng.Value
Dear expert,
I need a macro to reconcile account. The output of result are in attached
file by written function.
Thanks regards.
Ashish Bhalara
9099098307
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Hi Experts,
pfa refer attachment
Query I want macro which will create different workbooks according
tounique user column. and all workbooks will have name of user and
their data respectively in same format
Please help me.
--
FORUM RULES (986+ members already BANNED for violation)
1)
Dear Expart and Vikash,
Is there any group like this (excel-macros)
LAKSHMAN
From: Vikash Chandra vks.chan...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, April 17, 2012 6:22 PM
Subject: Re: $$Excel-Macros$$ Best resource to learn MS SQL
38 matches
Mail list logo