Hi,
attached is the solution.
On Mon, Nov 23, 2009 at 2:51 PM, Lavprasad Kori wrote:
> Attaching the solution of this problem.
>
> using COUNTIF formula.
>
>
> Regards,
>
> Lavprasad
> On Sun, Nov 22, 2009 at 12:30 AM, Mahavir Bhardwaj <
> virbhardwaj...@gmail.com> wrote:
>
>>
>> Dear All
>
On Nov 23, 3:22 am, Shujaat Ali wrote:
> Try this
>
> =B4 & " " &C4 & " " & D4
>
> & " " & => will put a space, whether the cells are blank or filled.
>
It's not the same column that's blank each time so you never know
where the space is going to be. I think I found the problem, there's
not a
> you can fill all the balnks with space.
> in order to do the same
> 1. select your range
> 2. press F5,
> 3. then clicke on special button
> 4. select blanks
> 5. press ok.
>
> this will select all the balnk cell in the range. then fill those balnk with
> space (all together by pressing ALTt+Ent
Dear Experts,
Please help to sum dr and cr seperately as file attached
--
Regards,
O.P.Sharma
Executive Manager- Accounts
M/S UBIO CHEMICALS LIMITED
VILL : AHMADPURA,ATRAULI
ALIGARH-U.P.
+91-9675202525
--
--
So
Dear All Experts
Please Help
Regards
Prasad Gadgil
Cell 9819442088
-- Forwarded message --
From: Prasad Gadgil
Date: Wed, Nov 11, 2009 at 10:10 AM
Subject: Re: $$Excel-Macros$$ Re: Creating Txn file
To: excel-macros@googlegroups.com, hemantbales...@gmail.com
Dear Heman
Dave,
Your soultion was spot on.
It executed immediately.
THANKS THANKS THANKS !
On Nov 21, 12:00 am, Dave Bonallack wrote:
> Hi Mike,
> Try this code. It may be quicker. But it won't go to the end of Col B if Col
> B has any blank cells. Let me know if this is a problem.
>
> Sub NumColA()
Hi,
In the attached file the basic data is in coloured cells.
What I want to achieve is that I want to list all items from the basic data
that are not zero in column A and that too alphabetically i.e A1, then A6
then A8 and so on.
Is there any method in excel so that I can do that.
Thanks
KK
-
thanks
2009/11/23 Mudassar Ramzan
> Dear Mahavir,
> take a look on attached file.
>
>
> *Regards,*
> **
> *Mudassar Ramzan*
>
> - Original Message -
> *From:* Mahavir Bhardwaj
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, November 23, 2009 4:41 PM
>
Thanks Vinod and Dave for ur help. I appreciate all ur
effortshowever...this still does not allow me to write new macro
or make changes in the macros in this excel file. it still asks for a
VBA password for same. Plz see if u guys can crack that password for
me or let me knw how to do this.
On
Here is a slight correction to my previous response. The eventhandlers
in the ThisWorkbook VBA module need to be modified as follows:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
UserForm1.cmdButton.Caption = "Close Workbook"
UserForm1.Show vbModal
End Sub
Private Sub Workbook_Befo
If I correctly understand what you are trying to do you could add a
UserForm to your workbook, add five checkboxes and one command button
and then place the following code in its VBA module:
Option Explicit
Dim b_UserIsFinished As Boolean
Private Sub CheckBox1_Click()
cmdButton.Enabled = All
Dear Mahavir,
take a look on attached file.
Regards,
Mudassar Ramzan
- Original Message -
From: Mahavir Bhardwaj
To: excel-macros@googlegroups.com
Sent: Monday, November 23, 2009 4:41 PM
Subject: $$Excel-Macros$$ Conditional Formating
Dear All,
hi sheetal!
why dont u copy the entire sheet.. and paste it on another (unprotected
sheet)..
a bit silly suggestion.. just chk if it works for u..
u wont atleast loose the working..
Regards,
Anubhav
On Sat, Nov 21, 2009 at 7:15 AM, sheetal lakhotia wrote:
> Hi Friends,
>
> Is there anyway to
Hi Sunil,
Attached file might help. I found it on net.
Cheers to the original programmer.
Best regards,
AJ
On Sat, Nov 21, 2009 at 2:27 PM, SSG wrote:
> Sir,
>
> Many times, it happens that we apply a filter on one or more columns.
> During the course of our handling and scrolling left-to-ri
Dear All,
I want to highlight friday and saturday using conditional formating:
*A B*
DateDay
01/11/2009 =weekday(a1)
02/11/2009 =weekday(a2)
03/11/2009 =weekday(a3)
04/11/2009 =weekday(a4)
05/11/2009 =weekday(a5)
06/11/2009 =weekday(a6
Thanks.
On 11/19/09, Dilip Pandey wrote:
> Hi Umed,
>
> Please find the solution attached with this email. Thanks.
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
> On Thu, Nov 19, 2009 at 5:5
Dear Sunil,
You can use the following UDF:
This Custom Function can be used to highlight them. Enter the following code
in a standard module. (Alt + F11, then Insert, Module from the top menu)
Function FilterOn(myCell As Range) As Boolean
On Error Resume Next
With myCell.Parent.AutoFilte
Dear Steve,
you can fill all the balnks with space.
in order to do the same
1. select your range
2. press F5,
3. then clicke on special button
4. select blanks
5. press ok.
this will select all the balnk cell in the range. then fill those balnk with
space (all together by pressing ALTt+Enter) .
attached herewith the solution of your question.
Regards,
Lavprasad
On Mon, Nov 23, 2009 at 2:31 PM, Steve wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use the concatenate funciton it
> leaves out the blank spaces and r
Hi,
The answer is in your questions only. Just put space in blank field.
I hope you got what I am trying to say.
Regards,
Swapnil.
On Mon, Nov 23, 2009 at 2:31 PM, Steve wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use
hi
CONCATENATE(IF(ISBLANK(A1)," ",A1),IF(ISBLANK(B1), " ",B1),IF(ISBLANK(C1), "
",C1),IF(ISBLANK(D1), " ",D1),IF(ISBLANK(E1), " ",E1),IF(ISBLANK(F1), "
",F1),IF(ISBLANK(G1), " ",G1),IF(ISBLANK(H1), " ",H1)
also attached in workbook
On Mon, Nov 23, 2009 at 2:31 PM, Steve wrote:
>
> I am try
Attaching the solution of this problem.
using COUNTIF formula.
Regards,
Lavprasad
On Sun, Nov 22, 2009 at 12:30 AM, Mahavir Bhardwaj wrote:
>
> Dear All
>
> please find enclosed herwith a file with my problem.
>
> Pls help
>
> Mahavir
> 2009/11/21 Aindril De
>
> Attach a file in reply to thi
HI Steve,
You can insert a blank space ( as long as you want ) in a cell & include that
cell in your concatenate formula every time you need space in between.
The cell will be visible as empty one but it will be having a space in it.
ANURAG SINGH ASWAL
This Communication is Confidential. We
I am using VBA in Access 2007 to automate a PowerPoint 2007
presentation. Each slide has a footer on it. How can I find the
shape of the footer and change the font and color on it for each
slide?
Or even better, how could I remove all of the footers from the slides
and create a custom footer on
Try this
=B4 & " " &C4 & " " & D4
& " " & => will put a space, whether the cells are blank or filled.
hope it helped.
On Mon, Nov 23, 2009 at 12:01 PM, Steve wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use the con
I am trying to concatenate 8 columns, all of which containe either a
single character or a blank. When I use the concatenate funciton it
leaves out the blank spaces and runs all the letters together (without
spaces). Is there a way that a blank cell can be concatenated as a
blank space? Can I
Please expklain more
I gues you want this
Cell A1 = test
Cell A2 = len(A1)
Frederik van Lierde
http://Blog.SilverSandsAssociates.com
Do you already follow us? http://twitter.com/SilverSands_IT
On Nov 19, 7:50 pm, mahavir wrote:
> Pls help
--
27 matches
Mail list logo
