Hi, If you can open the file in Read-only mode, then do so, make the changes
you want, then Save As whatever name you want. Then just delete the original.
Regards - Dave
> Date: Fri, 20 Nov 2009 17:59:46 -0800
> Subject: $$Excel-Macros$$ Urgent Help Needed
> From: sheetallakho...@gmail.com
> To:
Hi Friends,
Is there anyway to remove or crack the VBA password from the an excel
file. As soon as u double click to open the file. It gives a message
that Enter password for write access or open read only.
My colleague who created this sheet has forgot the password and we
need to make changes in
What I need to do is insert a column at A:A
if there is data in B1 number A:1 as 1
down one to B2 number A:2 as 2
and so on to the end of data in column B
start with this
Col A
aaa
bbb
ccc
end with this
Col A Col B
1.aaa
2.bbb
3.ccc
(dots shown here as spacers)
The co
I am unsuccessfully trying to set TickLabelSpacing for X-axis in a
chart-sheet. Tries recording the steps into a macro, but the recorded
code
returns an error when i attempt to run it myself.
The problem has something to do with the fact that the charts in
chart-sheets aren't embedded into ChartObj
Thanks Sandeep,
This is simplest way and yes the assumption is correct...the assumption
sustains as it is assumed.
Best Regards
Pooja Sharma
On Fri, Nov 20, 2009 at 8:13 PM, Sandeep Kumar Maurya wrote:
> Hi,
>
> Find the attached sheet with formula.
>
> Regards
> Sandeep
>
>
> On Fri, Nov 20,
Ooops. I forgot to mention that you need to explicitly reference the
MS Outlook library for the code I posted to be able to run by
selecting Tools | References from the VBE main menu and then select
'Microsoft Outlook 11.0 (or 12.0) Object Library' from the 'Available
References' list.
Best wishes
I am not quite clear exactly when you would like an email to be sent.
Is it when you change a cell in column A ('Subject Line') or when you
update an email address in column D. Anyhow here is code that you
could place in the VBA module associated with the worksheet you would
like to respond to chan
Hi Manoj,
I already suggested you the way which is possible using formula. I have a sound
grip on formulas and didn't know one which let you handle the cell color. So
the alternative is on Coding side which you already have.
BTW how you color cells. Is there any condtion for that (no matter if
Hi Sandeep,
Thanks for your consideration on this but i was looking for some kind of
formula so that whenever any coloured cell get any value, the sum formula
get update automatically.
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
On Fri, Nov 20, 2009 at 7:52 PM, Sandeep Kumar Maurya wrot
Hi Anil,
You can vlookup function. Please see the attached file for your
information.
Regards,
R. SHIVAKUMAR
On Thu, Nov 19, 2009 at 10:28 AM, Anil Saxena wrote:
> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>A
Hi,
Find the attached sheet with formula.
Regards
Sandeep
On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S wrote:
> pooja Sharma
>
> Find attached an excel file with vba macro. place ur cursor anywhere in
> reference column and run macro... u will see result in next sheet Hope
> this helps
Hi,
You can filter on the basis of color in excel 2007. And with that you can
use subtotal(9,Range) for your data.
Subtotal don't sum those value which are hidden.
Thus you can get sum on the basis of color in excel 2007 using filter and
subtotal.
But if you want to see both value at time then
Hi Manoj,
I've looked at XL2007, but it appears I was mis-informed. I see no built-in
function for summing by colour. Sorry.
Regards - Dave.
Date: Thu, 19 Nov 2009 13:40:27 +0530
Subject: Fwd: $$Excel-Macros$$ How to sum on the basis of color
From: manojsnegi.uttranc...@gmail.com
To: excel-macr
HI Rolf
I got it, Thank you.
On Fri, Nov 20, 2009 at 2:42 PM, vinod rao wrote:
> Hello Rolf,
>
> Can you plz put it in xls file?
> Thanks
> vr
> On Fri, Nov 20, 2009 at 11:58 AM, RolfJ wrote:
>
>> This might work for you. Let's assume that the total numbers of
>> minutes is located in cell A2
Hi Anil,
It seems the file you have attached has virus in it.
I have created a sample solution for you. Attaching the File.
Hope this Helps...
Let me know if u need further help.
Regards,
Andy
On Fri, Nov 20, 2009 at 1:47 PM, Anil Saxena wrote:
> Hi Ayush/Dilip
>
> plz How I can change index n
15 matches
Mail list logo
